Query result of combo box

[AccessDabbler]

I'm so confused I don't really know how to ask this...

I'm using Allen Browne's Recurring Event database as a base for my database. I'm scheduling appointments. In the frmEvent I have a combo box (cmboClient) that brings up my clients and posts the resulting information to Client_Name, Client_Address, etc. The cmboClient shows only the Client_ID (primary key from the Client_Table). How do I preform a query that shows the Client's Name etc from just the Client_ID?

I hope that makes sense...

 

[GinaWhipp]

You need to add a RowSource to your Combo Box. In this example I am using a query...

RowSource = SELECT qryClientNames.cpClientID, qryClientNames.Client FROM qryClientNames;
Bound Column = 1
Column Count = 2
Column Widths = 0.3";1.75"
List Width = 2.5"

Or is that not what you are asking?