I have a subform datasheet that shows a list of employees, their department, and their supervisor. I would like the supervisor field to be a combobox that only shows employees who are in the same department as the employee on each row. can a query be written for the combobox that refers to the department textbox on each row?
for example, if Fred is in Sales, I would like the combobox on the same row to show all employees who are also in Sales
for example, if Fred is in Sales, I would like the combobox on the same row to show all employees who are also in Sales
