Filter combo box based on another unrelated combo box

K

Kevin

Any help would be appreciated.

I have a form that has two combo boxes one being Service Type and one being
Assign Employee. The Service Type combo box is called CategoryID and the
Assign Employee combo box is called EmplID. The combo boxes are unrelated
but I would like to filter/limit available employees based on service type.
Example - Service Type = Mowing (CategoryID=23), the Assign Employee combo
box row source has (EmplID=100) and also has a field called CrewLead which is
a Yes/No field. If Service Type = CategoryID of 23 then only list employees
where CewLead =True, otherwise list all employees.

Is this possible?

Thanks Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top