Combo Box Result to Filter other combo boxes

[spectraflame]

Currently I have a combo box that list the different departments of our company on a form. I also have other combo boxes on that same form that list things like project number and employee name(s).

I would like to filter out the project number and employee name combo boxes based on the selection of the department combo box.

Ex: I select "Water" from the department combo box. Now the only selections in the project number combo box relate to the water deparment and the employees in the various employee combo boxes are only employees from the water department.

I have a separate table for project numbers that lists the project number, project description, and project department. I also have a separate table for employees that list employee ID, employee name, and employee department. Not sure if this information will be useful or not, but wanted to include it.

Matthew

 

[bat17]

generaly you need to wrap text in single quotes but not numeric data.

Peter