Requery after return from Popup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that calls a Popup form. When I close the Popup and return to
the underlying form. I would like to requery for that Underlying form.

How would I Requery (simply Me.Requery)?
And
What event would I use to set it off?
I was thinking of GotFoucs, but that would set it off the first time in. I
think I need something like 'Reacquire Focus'.
 
Hi,
One way is to put a Public Function (RequeryMe) in the underlying form that
runs the code - Me.Requery - then you can call that Function from the PopUp
in the Form_Unload Event --- Form_UnderlyingFormName.RequeryMe
:-)
 
Two ways:
1. Onexit of your popup form write Forms!
[MyFormName].requery
2. On the Activate property of the form write me.requery
 
Thanks

I had a button to close form on Popupand used the click event with
Forms!frmReturnInspection.Requery


Tnaks again
 
Back
Top