Hi,

I couldn't find anything regarding my specific dilema.  I simply need to
maintain a dropdown that lists my users so we can track who entered which
record.  My original dropdown selected the values of RequestorName from a
table called tblRequestors that the fields RequestorID, RequestorName and
Function.

This worked fine until someone left and we didn't need to see their name in
the list anymore.  When I deleted their entry from tblRequestors, all records
they had entered showed a blank value for the Requestor field.  

This is no good because most of reporting is dependant on the function of
the requestor that is tied to the person's name in tblRequestors.  Also, even
if a person leaves our team we still want a history of which records they
created.

I tried adding a yes/no field on tblRequestors called Active.  I then used
the following for the row source: SELECT tblRequestor.RequestorID,
tblRequestor.RequestorName, tblRequestor.Function FROM tblRequestor WHERE
(((tblRequestor.Active)=True)) ORDER BY tblRequestor.RequestorName;

Unfortunately, this produces the same result as before.  When I deselect
Active for a requestor's name on tblRequestors, their individual records have
blank requestor fields.  Can anyone please tell me what I'm doing wrong?

Thanks,
Jim