I solved it with the following code:
Code:
SELECT EmployeeDB.[Last Name], EmployeeDB.[First Name], EmployeeDB.State, EmployeeDB.[Phone Number 1], EmployeeDB.[Phone Number 2], EmployeeDB.[Basic+], EmployeeDB.TWIC, EmployeeDB.HAZWOPER, EmployeeDB.Hydroblasting, EmployeeDB.[Scaffold Builder], EmployeeDB.[Confined Spaces], EmployeeDB.[OSHA 10], EmployeeDB.[OSHA 40], EmployeeDB.[CDL w/VAC], EmployeeDB.[CDL (standard)], EmployeeDB.[Valid Driver's License], EmployeeDB.[Job Types], EmployeeDB.[Site Specific Training 1], EmployeeDB.[Site Specific Training 2], EmployeeDB.[Site Specific Training 3], EmployeeDB.[Site Specific Training 4], EmployeeDB.[Site Specific Training 5], EmployeeDB.[Site Specific Training 6], EmployeeDB.[Eligible for Rehire], EmployeeDB.Status
FROM EmployeeDB
WHERE (
(([Forms]![EmployeeListMenu]![ComboState1] Is Null) And ([Forms]![EmployeeListMenu]![ComboState2] Is Null) And ([Forms]![EmployeeListMenu]![ComboState3] Is Null) And ([Forms]![EmployeeListMenu]![ComboState4] Is Null)) Or ((EmployeeDB.State = [Forms]![EmployeeListMenu]![ComboState1]) Or EmployeeDB.State = [Forms]![EmployeeListMenu]![ComboState2]
Or EmployeeDB.State = [Forms]![EmployeeListMenu]![ComboState3] Or EmployeeDB.State = [Forms]![EmployeeListMenu]![ComboState4]));
Thank you for your help - it did help in the end, just in a different way!