Auto Updates

K

Kerry

I have a client listing form which lists ALL clients that have been entered.
On this form it has a button for users to press which brings up a popup form
to 'add' a new client. When you close the popup form, the listing form is
not updated unless you close the listing form and reopen it. Is there any
way that I could get it to update as soon as the popup form is closed??

Any help would be much appreciated.
Thanks.
 
J

Jeff Boyce

Kerry

I believe you need to tell your underlying form that it has a new entry. In
the code behind your button, you could add the following after the code that
pops up the add new client form:

Me.Requery
 
B

Brian

Kerry said:
I have a client listing form which lists ALL clients that have been entered.
On this form it has a button for users to press which brings up a popup form
to 'add' a new client. When you close the popup form, the listing form is
not updated unless you close the listing form and reopen it. Is there any
way that I could get it to update as soon as the popup form is closed??

Any help would be much appreciated.
Thanks.
Click to expand...

Try the "Requery" method.
 
K

Kerry

The button that you press to bring up the popup form has a macro to open the
popup. In this case, where would the requery go?

Thanks.
 
J

Jeff Boyce

Kerry

Open the macro in design mode. Add a new action below the popup action. I
believe the Action you want is "Requery"
 
K

Kerry

I have just tried that, but it still does not refresh automatically. Is there
something I am missing? Or something else I should be doing?

Thanks!
 
J

John Spencer (MVP)

I don't think this will work if the POPUP form is just a popup form. The Form
has to be opened in DIALOG mode to force the calling code to halt. I think that
you can do that with a setting in a macro (Window Mode: Select "Dialog")
 
J

Jeff Boyce

Good point, John. I was assuming (silly me!) that the OP had focus/control
staying on the pop up (i.e., in "dialog" mode).

Jeff
 
Top