Display a range in a combo box based on a field entry

[justair07]

Hello,

I have a table called employee roster. This table holds the names of the employees, managers, shifts, and departments.

Here is what I would like to be able to do:



On a form, once the manager's name is selected, only his employees will display (not everyone). Once the employee is selected, the shift and department will auto populate in the form based on the data from the employee roster table.

Can someone please help me with the easiest way to do this. Do I need a macro?

Thank you,

-Justair

[June7]

Perhaps this will help:

http://datapigtechnologies.com/flash...tomfilter.html

http://datapigtechnologies.com/flash...combobox2.html