I ran across this example of code that creates a filter on one combo box based on another combo box selection:
http://www.databasedev.co.uk/filter_combo_boxes.html
The example is only based on two combo boxes. I have three that need to filtered by Director, Manager and Employee.
The example worked great for the first two boxes. When I selected a Director from the combo box all of the managers are filtered in order to select only his direct reporting managers. However, when I tried to apply the same filter to the "Manager" combo box in order to filter the third "Employee" box (basically just copying the same code and renaming tables and fields for the employees) I started receiving a compile error when a "Manager" is actually selected. It did not do this until I tried to apply the employee filter code.
I hope my explanation makes sense. I have attached the database and if you open the form "frm_TBERD-8000-BERT" select a Director and then select a Manager you will see exactly what I mean. I apologize for my terrible naming convention. The Director combo box is named "Combo39", the Manager combo box is "Manager" and the employee box is "Combo37".
Any help will be very appreciated.
thanks,
Mark A.
http://www.databasedev.co.uk/filter_combo_boxes.html
The example is only based on two combo boxes. I have three that need to filtered by Director, Manager and Employee.
The example worked great for the first two boxes. When I selected a Director from the combo box all of the managers are filtered in order to select only his direct reporting managers. However, when I tried to apply the same filter to the "Manager" combo box in order to filter the third "Employee" box (basically just copying the same code and renaming tables and fields for the employees) I started receiving a compile error when a "Manager" is actually selected. It did not do this until I tried to apply the employee filter code.
I hope my explanation makes sense. I have attached the database and if you open the form "frm_TBERD-8000-BERT" select a Director and then select a Manager you will see exactly what I mean. I apologize for my terrible naming convention. The Director combo box is named "Combo39", the Manager combo box is "Manager" and the employee box is "Combo37".
Any help will be very appreciated.
thanks,
Mark A.
