Maybe giving the row sources for the other combo boxes will help. I must be doing something wrong if it works for you.
Department Cbo
Code:
SELECT DISTINCT Directory.Department FROM Directory ORDER BY Directory.Department;
Division Cbo
Code:
SELECT DISTINCT Directory.Division, Directory.Department FROM Directory WHERE (((Directory.Department)=[dept])) ORDER BY Directory.Division;
Function Cbo
Code:
SELECT DISTINCT Directory.Function, Directory.Department, Directory.Division FROM Directory WHERE (((Directory.Department)=[dept]) AND ((Directory.Division)=[div])) ORDER BY Directory.Function;
Category Cbo
Code:
SELECT Directory.ID, Directory.Category, Directory.Department, Directory.Division, Directory.Function FROM Directory WHERE (((Directory.Department)=[dept]) AND ((Directory.Division)=[div]) AND ((Directory.Function)=[fun]));