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.