Search results

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...

My database is used to store emplyee skill training levels and some basic employee information. I have attached a screen shot of the tables used and their relationships. I am using a search form named [search_frm]. The form contains unbound comboboxes and a command button [Search] that runs...