Insert into (1 Viewer)

[jedder18]

I have a main form which has a couple of controls being populated with a query.
I want to have those controls (if null) inserted into a subform containing a table.
Where do I put the expression Insert Into on that control?
After Update?
Any and all help appreciated.

 

[Ranman256]

well, if you have several controls getting populated, wait till all are done, then click a button to execute the query.
btnSave_click()
docmd.openquery "qaInserQry"
end sub

 

[jedder18]

There are numerous controls on numerous pages of the main form...(bad design..)
the query would be really complicated.
the subform table needs populated by all the controls on the numerous pages.
Over 40 controls.
then subform will show on all pages with updated data.