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.
 
Back
Top