How to get match user’s input password from the records (1 Viewer)

[SachAccess]

Hi,

I have a FORM. This Form has two fields.
First is User ID and second is Password.
First field is auto-filled by the code (user name).
Second field is a text-box, where user needs to enter the password.
Once user enters the password he clicks on LOGIN button on the form.

My work here is to check if the user has entered correct password.
I have a table with user details. Table name is Tbl_Employee_Details.
Third field from this table is User_Name, fourth field from the table is User_Password.

I am not able to understand how to write a query to get the password details for the user.
I tried writing WHERE query but not able understand how to get derive password from the table based on the user.
Can anyone please help me in this. Thanks.

 

[June7]

If all you want is password, don't need query. Use DLookup() function.

If Me.tbxPassword = DLookup("User_Password", "Tbl_Employee_Details", "User_Name='" & Me.tbxName & "'") Then

 

[SachAccess]

Hi @June7 sir, thanks a lot for the help. It is working great. Have a nice day ahead.