Validate User Login Credentials

[Joe B.]

Hi All,

I have created a user login form with two test boxes, one for Employee and the other for Password. I also created a Command button to Enter. I then created an Employees table with three fields, ID, EmployeeName, and Password.

How can I get the Command button to validate the Employee Name and associated Password are in the table when the user clicks the button.

Thanks and enjoy the weekend.

Joe B.

 

[pbaldy]

One way:

If DLookup("UserPassword", "tblUsers", "UserName = '" & Me.txtUserID & "'") <> Me.txtPW Then