Selecting a Particular Client

[jsccorps]

I have a form that includes client information and a subform that includes
associated purchase information. All of the records are available, and a
user can navigate (next, back) through the records. How can bring up the
form (and associated subform) for a particular client, for example based on
Client ID?

 

[bhicks11 via AccessMonster.com]

I would offer the user a small form with a combobox on it. The data source
of the combobox would be the clientID - though I would show the user the
client name, etc.

Set the filter of the form to: forms!smallselectform.comboboxname

In the OnExit event of the combobox, open the form and it will filter on the
small form. If you get into it and need help, happy to help.

Bonnie
http://www.dataplus-svc.com

 

[fredg]

I have a form that includes client information and a subform that includes
associated purchase information. All of the records are available, and a
user can navigate (next, back) through the records. How can bring up the
form (and associated subform) for a particular client, for example based on
Client ID?

Add an UNBOUND combo box to the Main Form's Header.
If you use the wizard to do so, select the 3rd option on the first
list of question, something like "Find a record..."
Complete the wizard.
When you are done, selecting a client from the combo box will take you
to that client's record.