Combo Box help

[aotke1110]

I have created a form with the main table Clients, containing an auto-generated primary key (ClientControl) and client name. The client name is stored as a text box in the table. There are 3 sub forms within this form with data from tables that all have ClientControl as a foreign key. Within the form I am trying to make the Client Name field a combo box so that the user can select from a list of clients in order to see the associated details in each of the sub-forms. The problem currently is that when i select a different name in the combo box it saves my selection as the the name for whatever record is up.

Basically i want to use the combo box as a navigation tool between Client records but I have set it up incorrectly currently.

[June7]

Controls used to enter filter criteria must be UNBOUND.

Options for using the combobox:

1. dynamic parameterized query as the form RecordSource, parameter references the combobox for input

2. VBA procedure to set the form Filter and FilterOn properties