qcdennis 0 Newbie Poster

I'm probably overthinking and been staring at this too long, but I'm having a huge brain fart and need help.

I have 3 fields on a form: EMPLOYEE (visible), EMP NUMBER (not visible) (from a seperate table) and EMP NUMBER ENTRY (visible).

I want the employee to choose his/her name from a pull down (I got that) and enter their "employee number" in the EMP NUMBER ENTRY field, then have it compare for an exact match in the invisible EMP NUMBER field before they can proceed to another menu. In essence, each employee has their own password (their employee number).

Thx for the help