Hi
I wonder if someone could please point out why I'm getting this error when logging into my db:
Runtime Error 3705: Syntax error (missing operator) in query expression '[UserName]=Bob Smith'
When I select debug this is the code it highlights:
I'm stumped as to what the issue is but it's probably something glaringly obvious.
I wonder if someone could please point out why I'm getting this error when logging into my db:
Runtime Error 3705: Syntax error (missing operator) in query expression '[UserName]=Bob Smith'
When I select debug this is the code it highlights:
Code:
If Me.TxtPassword.Value = DLookup("PWD", "tblUsers", _
"[UserName]=" & Me.TxtUsername.Value) Then
I'm stumped as to what the issue is but it's probably something glaringly obvious.