asked on Run time error Access 2010
When I put the below in my forms Current event
----------------
If DLookup("TickBox","table2"
Me.lblComplete.Visible = True
Me.Image.Visible = True
Else
Me.lblComplete.Visible = False
Me.Image.Visible = False
End If
--------------
I get the following error message when I try adding a new record because the 'ContactID' field is empty. Can anyone advice?
-------------------
Run-time error '3075':
Syntax error (missing operator) in query expression 'ContactID = '.
------------------
----------------
If DLookup("TickBox","table2"
Me.lblComplete.Visible = True
Me.Image.Visible = True
Else
Me.lblComplete.Visible = False
Me.Image.Visible = False
End If
--------------
I get the following error message when I try adding a new record because the 'ContactID' field is empty. Can anyone advice?
-------------------
Run-time error '3075':
Syntax error (missing operator) in query expression 'ContactID = '.
------------------
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If DLookup("TickBox","table2"
Me.lblComplete.Visible = True
Me.Image.Visible = True
Else
Me.lblComplete.Visible = False
Me.Image.Visible = False
End If