You canceled the previous operation

[Neil via AccessMonster.com]

i keep getting this error message when using DLookup

here is my code
If Me.Password.Value = DLookup("[Password]", "Users", " [UserName]= " & Me.
UserName.Value) Then
any sugestions as this getting anoying
thanks Neil

 

[Allen Browne]

The message indicates the the DLookup() could not be calculated because one
of the arguments is invalid.

If UserName is a Text field (not a Number field), you need additional quotes
in the 3rd argument. Try:
DLookup("Password", "Users", "[UserName] = """ & Me.UserName & """)

 

[Neil via AccessMonster.com]

Thanks that was the problem
changed it to this
If Me.Password.Value = DLookup("[Password]", "tblUsers", " [UserName]= '" &
Me.UserName.Value & "'") Then
and it worked a treat

Thanks

The message indicates the the DLookup() could not be calculated because one
of the arguments is invalid.

If UserName is a Text field (not a Number field), you need additional quotes
in the 3rd argument. Try:
DLookup("Password", "Users", "[UserName] = """ & Me.UserName & """)

i keep getting this error message when using DLookup

[quoted text clipped - 4 lines]

any sugestions as this getting anoying
thanks Neil