Help: combo box list needs to be dependent on what is entered in another combo box on same form.

[ExtremeNovice]

I have two combo boxes on my form.



The first box selects an Employee and is bound to the EmployeeID from the table: tblEmployee.
The second combo box selects the employee's pay rate and is bound to the PayID which is on a related table: tblPay.
(Employees can have a variety of different pay rates depending on the job they are performing.)

I need a SQL statement for the row source of the PayID combo box that will only display the PayRate(s) for the EmployeeID that is selected in the first Combo box.

My Current PayID combo box row source SQL statement returns all pay rates for all employees:

SELECT tblPay.PayID, tblPay.EmployeeID, tblPay.PayRate FROM tblPay;

I am hoping that it is as easy as adding a WHERE condition but I have tried several different approaches and haven't had any success.

[CJ_London]

change your payid rowsource to

SELECT tblPay.PayID, tblPay.EmployeeID, tblPay.PayRate FROM tblPay WHERE tblPay.EmployeeID=[cboEmployee]

where cboEmployee is the name of the employee combo

then, in the employee combo after update event put

cboPayID.requery

[ExtremeNovice]

Awesome - Thank you!

To the other novice's who read this: I couldnt just type "PayID.requery" into the employee combobox after update event, I had to build a requery macro and set the PayID as the control name.