How do I get this unbound contol to lookup a password based on a parameter?

[Jesse Jones]

I have a form the records a process that we require to be authorized by a manager.

We want to check this authorization by a password. I was thinking a good way to do this is have a hidden, unbound text box lookup the proper password for the EID of the manager that entered their EID on the form. I was thinking have a VBA event that runs on exit from the control in which the manager enters their EID. Then, a simple if function that compares the password entered to the hidden password lookup would allow or halt the recording of the information in the controls.

Could someone please help me with the best way to get the hidden field to lookup the proper password?

Thank you.

[Jesse Jones]

Sorry. I found my own code I had posted on here from the last time I did this in response to someone else's problem.

Duh.

http://bytes.com/topic/access/answers/906731-how-make-login-form-vba-validates-username-password