I have an emplyee database with tbl_employees, fields for name address phone,
etc... I have another table for locker assignments, lockernumber, and a
assigned to field combo box based on:

SELECT tbl_employees.EmployeeID, [LastName] & ", " & [FirstName] AS Contact,
tbl_employees.LastName, tbl_employees.FirstName, tbl_employees.Active
FROM tbl_employees
WHERE (((tbl_employees.Active)=Yes))
ORDER BY tbl_employees.LastName, tbl_employees.FirstName;

this allows me to only assign lockers to active employees. this part works
well.

my issue is when a employee leaves, I change the status to inactive. in the
form for Lockers the name goes blank, which is what I wanted, however when I
check the actual table the combo box shows the employees number.

How do I make the field go blank, when a emplyee becomes inactive?
--
Dan