I have a form (myForm) which has the following combo boxes:
1) Shift (selects shift 1, 2, or 3 from tblShift) this value is not
stored in a field.
2) Department (selects Dept1, Dept2, or Dept3 from tblDept) this value
is also not stored.
3) Then I have a combo box for Employees' names. This list is
generated from tblEmployees w/ fields FirstName, LastName, Shift, and
Department.
On myForm, is it possible to select the Shift number, the Department
name and have Access only return the names of the corresponding
employees to my Employees name combo box so that the user only chooses
employee names for the chosen shift and department instead of the
whole plant?
Thanks in advance,
Tim