Requery Sub Form

  • Thread starter Thread starter John Kirkman
  • Start date Start date
J

John Kirkman

I have a form with two sub forms. After I select another record in subform1,
I need to requery(update) the information in subform2. I am using an after
update event from subform1 to change a hidden text box on the main form
which is used as the creteria for subform2. I just don't know how to update
the second subform. Thanks for any help.

John
 
In your AfterUpdate event, of SubForm1, but after you update the field on the
main form, use:

SubForm2.requery

Sharkbyte
 
Forms!MainForm!SubformCONTROL2.Form.Requery

Note that you must use the name of the SubformCONTROL which can be different
from the name of the Form you used as the Subform.
 

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

Syntax for Refreshing Control on Sub-Subform 6
Conditional Formatting on Subform 3
Accessing sub forms 2
How to unhighlight list item 3
Forms and subforms 3
Saving data 2
Linking subforms - 5
Automatically requery 1

Back
Top