requery form on return

[vicsaccess]

I have a main form, when a task is clicked on, it opens a new detailed view of that entry in another popup form and allows the user the ability to add details. at the same time the main form is staying open in the background. when I close the detailed form how is the best way to get the main form to requery when it has focus again to reflect the additions that were made?

[June7]

How do you open the popup - show that code.

[pbaldy]

Or try this in the activate event of the main form:

Me.Requery

[vicsaccess]

June, using a browseto to open the popup.
Thanks Baldy, the activate event worked.

[pbaldy]

Thanks Baldy, the activate event worked.

Happy to help!