Multiple Combo Boxes

I

ir26121973

Hi,

Wonder if someone can help me please.

I have a table consisting of Pay ID Numbers and the departments that they
are pertinent to.

I would like to have a form with two combo boxes on it, one with the Pay
ID's and the other with the Departments. When I select the Pay ID I would
only like the relevant Departments to be shown in the second combo box.

Does anyone know how to do this?

Thanks
 
A

Al Camp

IR,
Use the value in cboPayID to filter the query (RowSource) of cboDept. In the query
behind cboDept place this criteria agianst the PayID field
= Forms!frmYourFormNameHere!cboPayID
 
I

ir26121973

Al,

Thanks for this, I'll give it a try.

Chris

Al Camp said:
IR,
Use the value in cboPayID to filter the query (RowSource) of cboDept. In the query
behind cboDept place this criteria agianst the PayID field
= Forms!frmYourFormNameHere!cboPayID
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
 
Top