Multiple Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top