How to get subcategory to change when category is changed

[greysquirl]

I reviewed the thread above where they were asking how to update this particular function. What I am having a problem with is getting this far. I am using two tables, one is Department and the other is Supervisor. What do I need to add and what needs to be done to make it so that when I select a department from a combobox it only list the supervisors for that department in another combobox?

 

[jimmythegeek]

In the row source property of your supervisor combo box, put the following criteria on the DeptID, or Department field (change the red):

=[Forms]![YourFormName]![DeptComboBoxName]


Now on the After Update of the Department combo box put:

Me!SupervisorComboName.Requery Jim Lunde
compugeeks@hotmail.com
Custom Application Development