Requery Macro for a Form

K

Karen

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
 
S

Steve Schapel

Karen,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top