I'm working on a login form but I can't seem to get the vba code to work.
The main part of the code I'm using is:
The code that gets the error is:
Syntax error (missing operator) in query expression 'Access level'. I'm not even entirely sure what this means or how to fix it, I don't know what the missing operator is, I'm pretty sure I typed it correctly.
The main part of the code I'm using is:
If (IsNull(DLookup("Access level", "TBL Accounts", "Username = '" & Me.TXT_Username & "'"))) And (IsNull(DLookup("Access level", "TBL Accounts", "Password = '" & Me.TXT_Password & "'"))) Then
MsgBox "Incorrect username and password.", vbOKOnly
The code that gets the error is:
with the error:If (IsNull(DLookup("Access level", "TBL Accounts", "Username = '" & Me.TXT_Username & "'"))) And (IsNull(DLookup("Access level", "TBL Accounts", "Password = '" & Me.TXT_Password & "'"))) Then
Syntax error (missing operator) in query expression 'Access level'. I'm not even entirely sure what this means or how to fix it, I don't know what the missing operator is, I'm pretty sure I typed it correctly.