Lookup List

[Nell]

I have a database that contains client records. It includes the
fields ClientID#, FirstName, LastName and MI and other fields
(address, phone, etc.) for each client. I've created a form with
several tabs to display all of the client fields.

Now I need to find a way to create another control or form that
presents a list of the clients in the database and allows me to select
a client then jumps to that client's record. Does anyone know of a
way to do this or a site that shows examples of a lookup list like
this?

Thanks,

Stuart

 

[fredg]

I have a database that contains client records. It includes the
fields ClientID#, FirstName, LastName and MI and other fields
(address, phone, etc.) for each client. I've created a form with
several tabs to display all of the client fields.

Now I need to find a way to create another control or form that
presents a list of the clients in the database and allows me to select
a client then jumps to that client's record. Does anyone know of a
way to do this or a site that shows examples of a lookup list like
this?

Thanks,

Stuart

Add a Combo Box to the Form's Header section.
If you use the combo box wizard, select the 3rd option on the first
page of instructions, something like "Find a record ... etc".
Make sure you include the ClientID, as well as name field.
Hide the ClientID (the wizard will ask).

When completed, select the client in the combo box, and that client's
record will appear on the form.