Subform save in form table

[nadir66]

Hi
I have a form with a subform, where the two are not conected at all. The subform is a table with static data, and the forms table is dynamic.
how can i create a link and have the subform main subject saved ion the form table for further use and display.
To elaborate:
the subform contains all customer data, the form is a work docket to be filled.
thank you

 

[LaurieHamlin]

If I correctly understand what you're doing this should help. If you haven't already done so, you'll need to create a recordset. Use .Addnew to add a new record or .Update to change the data in that field in an existing record.
With rst
.Addnew
![tableFieldName] = formControlName.Value
.Update

or
sqlstr = "Update tablename Set [tablename].[fieldName] = '" & formControlName.Value & "' Where .....(add your criteria)
dbs.Execute (sqlstr)
Hope that works for you.