Requery Macro for a Form

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

Guest

I have an Issue data entry form. To select a client, the user clicks on a
search button. This opens the search form. If the client is not in the
combo box on the Search Form, the user can open the Client Info from the
search form and add the client info. When the user closes the Client Info
form, the search form is requeried and the user can select the new client for
the Issue form. The macro is set to the On Close event of the Client Info
form. However, this is only good when using the Client Info form along with
the Issue data entry form. If I use the Client Info form on its own and
close it, the macro will open the Search form.

The macro is:
Select Object: Form: FrmSelectClient
Restore
Requery: Group Name

Where else can I place the macro or how can change the macro.

Thanks
 
Karen,

You could try Requerying the combobox on the Activate event of the
Search form. Or the Enter event of the combobox itself.
 
Back
Top