Requery Sub Form

[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

 

[Guest]

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

SubForm2.requery

Sharkbyte

 

[Van T. Dinh]

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.