Requery after return from Popup

N

NNlogistics

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'.
 
G

Geoffs

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
:)
 
O

Ofer

Two ways:
1. Onexit of your popup form write Forms!
[MyFormName].requery
2. On the Activate property of the form write me.requery
 
N

NNlogistics

Thanks

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


Tnaks again
 
Top