Syntax help needed for DLookup

This is so frustrating. I have asked a similar question over the years no less than 10 times. All of the answers are in my knowledge base and I still can't figure it out.

I am getting a #NAME? error for this:

DLookup("UserType", "tblUsers", "Password = " & Chr(34) & Me.Password & Chr(34) & " ")

Me.Password is text.
Dale LoganConsultantAsked:
Who is Participating?
MINDSUPERBConnect With a Mentor Commented:
If the above is not working:

Try this one:

DLookup("UserType", "tblUsers", "[Password] = '" & [Password] & "'")

Try this:

DLookup("UserType", "tblUsers", "Password = '" & Me.Password & "'")

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.