Multiple Combo Boxes

[Guest]

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

 

[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

 

[Guest]

Al,

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

Chris

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