I am working on a small project that has Client information stored on Access 97.
The problem is a Client may have more than one account number.
On the Data Entry Form I have a Combo Box ( Source Clent Name from dtaClient) and I want to be able to select Client and Account Number is entered into a label box.
I have written code before for One Client - One Account and the code is as follows ;

Private Sub cmboClient_Click()
Form1.dtaClient.Recordset.MoveFirst
Form1.dtaClient.Recordset.FindFirst "Client = '" & _
Trim(Form1.cmboClient.Text) & "'"
Form1.lblAccount = Form1.dtaClient.Recordset.Fields _
("Account").Value

This lists only the first Client Name and Account Number eg.
Name - Smith Account - 123
I want to be able to Click and the other accounts are listed as well eg.
Combo Box Account
Smith 123
Smith 456
Smith 789
I can't use the AddItem as Combo Source is from the Access Database Table Clients.

I tried using a cmd Button with FindNext but it does not pick up if more than two accounts and only works on first entry.

Hope someone can help.
Regards,
Trevor