Requery Main Form After Closing Pop-up

[S Jackson]

I have a form with a button for the user to click to a add record. A pop-up
form opens allowing the user to add the record. When they close the pop-up
the new record does not appear among the records being displayed on the main
form. In order to see the newly created record, the user has to close the
main form and then re-open it. How do I requery the main form after the
pop-up is closed? I tried putting code (Docmd.Requery) under the Got Focus
event on the main form, but it did not work - the form did not requery.

TIA

 

[Jason]

In the close event for the pop up form use the code:
Forms!frmWithAButton.Requery

 

[S Jackson]

Thanks! That worked.

In the close event for the pop up form use the code:
Forms!frmWithAButton.Requery