Getting to a record by click of a record in a combo box

[Jack]

Hi,
I am new to Access. I have to build a form where a combo box contains
clients alpha-numeric id number and name. From the combo box, if one
particular client is chosen, then this would display all the details of the
record corresponding to that particular client number(we have one detailed
record per client). However the combo box should be always be there so that
one can choose another client number and get the details of that client in
the form.

I have no idea how to handle this. I would appreciate any help on this e.g.
article, whitepaper etc. Thanks in advance. Regards.

 

[Amit]

Hi,
I am new to Access. I have to build a form where a combo box contains
clients alpha-numeric id number and name. From the combo box, if one
particular client is chosen, then this would display all the details of the
record corresponding to that particular client number(we have one detailed
record per client). However the combo box should be always be there so that
one can choose another client number and get the details of that client in
the form.

I have no idea how to handle this. I would appreciate any help on this e.g.
article, whitepaper etc. Thanks in advance. Regards.

Hi Jack,

Try this. Assuming that Client ID is the Primary Key.

1. Create a form bound to the table/query with controls for the
fields/records you want to see on the form.

2. (Preferably) In the header/footer of the form, add a combo-box and when
the combo-box wizard window appears, select the third option - "Find a record
on my form based on the value I selected on the combo-box".

3. Select the fields you want to see in the combo-box (Client ID and Client
Name, with the assumption that Client ID is the Primary Key).

4. I'd suggest hiding the Client ID and have only the Client Name visible in
the combo-box, but this is your decision.

You should be all set.

Another excellent resource for common issues/answers is
http://www.mvps.org/access/

Cheers,

-Amit