Requery after return from Popup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NNlogistics - 12 Apr 2005 15:35 GMT

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

Signature

Thanks for any assistance

Reply to this Message

Geoffs - 12 Apr 2005 16:04 GMT

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

:-)

> 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.
[quoted text clipped - 4 lines]
> I was thinking of GotFoucs, but that would set it off the first time in. I
> think I need something like 'Reacquire Focus'.

Reply to this Message

NNlogistics - 12 Apr 2005 16:37 GMT

Thanks

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

Tnaks again

> Hi,
> One way is to put a Public Function (RequeryMe) in the underlying form that
[quoted text clipped - 10 lines]
> > I was thinking of GotFoucs, but that would set it off the first time in. I
> > think I need something like 'Reacquire Focus'.

Reply to this Message

Ofer - 12 Apr 2005 16:21 GMT

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

>-----Original Message-----
>I have a form that calls a Popup form. When I close the Popup and return to
[quoted text clipped - 5 lines]
>I was thinking of GotFoucs, but that would set it off the first time in. I
>think I need something like 'Reacquire Focus'.

Reply to this Message