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
Updates in forms and subforms 1
Access Daily Entry with multiple entries per field 0
Referencing Subforms 1
AfterUpdate event procedure 5
Creating and running a module to Refresh data in subforms 5
Requery a sub table 1
Access form update/Requery? 1

Top