Auto Updates

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

Guest

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

Open the macro in design mode. Add a new action below the popup action. I
believe the Action you want is "Requery"
 
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!
 
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")
 
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
 
Back
Top