activate a form after a popup

[gerard1979]

Access 2000
I have a form and want to requery it after updating an popup
form.
I'll try to use the Form_activate. The problem is: an popup is not sensible for activate and deactivate.
How can I handle this?

Tnx in advance,

gerard

 

[oharab]

After the code to close the pop up put something like

Forms!frmMain.requery
or
Forms!frmMain.rowsource=Forms!frmMain.rowsource

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[gerard1979]

It's working, tnx.
But... now I have to put the code in every popup form
So, better to put code in the mainform
It's a form --> subform --> subform situation
The last subform has to requery

Any suggestions?

 

[oharab]

Ahh subforms!
curse and blessing in equal measure! ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------