Confusing Select/Theory

For this problem, I have two tables:
(I am creating an employee scheduling app)
tblEmployees
tblShifts

I have 5 different locations an employee can work at.
In tblEmployees I have 5 checkboxes, one for each location.

I have code in place that:
1 Gets a location
2 Gets a shift to be filled
3 Finds an employee to fill the shift

I am confused on how to select the employees.


'curLocation is the current location we are working with
"Select from tblEmployees Where x = ' " & curLocation & " ' "


My problem is 'x'. How do I make x, which is essentially check boxes = the current location?

Do I need to create another sub with a CASE that sets variables ?

You will need some form of conditional branching to specify which field the WHERE clause will apply to.