Subforms

D

DW

If you have a main form and sub form, and if updating the data in the subform
causes related data in the main form to change after a macro procedure, how
do you get the data in the main form to update? The underlying query has
parameters, so I don't want to re-run the query during an update, because
that would force the user to re-enter the parameters every time the recordset
is updated.
 
P

pietlinden

If you have a main form and sub form, and if updating the data in the subform
causes related data in the main form to change after a macro procedure, how
do you get the data in the main form to update? The underlying query has
parameters, so I don't want to re-run the query during an update, because
that would force the user to re-enter the parameters every time the recordset
is updated.
Click to expand...

Call the Requery method of the main form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery a parameter query 1
Adding data to MS Access from csv file 0
Updates in forms and subforms 1
Populate main form from subform record 0
Consolidation Table from Different Excel Tabs with Different Format 1
Referencing Subforms 1
How do I clear a form? 0
Access form update/Requery? 1

Top