I think you can do a "DLookup" function within your text box. Put an unbound text box on a form. In the control source of the text box, put
=DLookup("EmployeeName", "Employees", "Password = " & yourPasswordVariableName). The syntax will need to be tweeked, but basicall you are telling the...