User and pass form

[hitesh_asrani_j]

Can some one help me solve the User Name and password form..

I have a table which has three columns ID, Employee and Password (with the same name)

I have form with two texts and one button.

Text one is user name (named EMP)
Text 2 is password (name PASS)

The table is tblEmployees

I used the code builed and inserted the following code for checking for the user and pass..




"

If Me.PASS.Value = DLookup("Password", "tblEmployees", "[Employee]=" & Me.EMP.Value) Then

DoCmd.Close acForm, "UserPassForm", acSaveNo
DoCmd.OpenForm "Data"

End If"

But the code is returning the error as

"The expression you entered as a query parameter produced this error : "Hitesh" (one of the usernames i inputed)



help me....!!!! PLEASE

[June7]

Hitesh is text, text must be enclosed in apostrophe delimiters (dates would be #), like:
DLookup("Password", "tblEmployees", "[Employee]='" & Me.EMP.Value & "'")