NickHa,
Thanks for replying. The combo boxes row sources are as follows:
Employee: SELECT DISTINCT Emp_tbl.Employee FROM Emp_tbl ORDER BY Emp_tbl.Employee;
Dept_Line: SELECT DISTINCT Emp_tbl.Dept_Line FROM Emp_tbl;
Shift: SELECT DISTINCT Emp_tbl.Shift FROM Emp_tbl ORDER BY Emp_tbl.Shift...