Thank you for your response.

When I change the last part of the code to tblTrackingData .[SAP Security Role] = True" & _ I get the same error message as when I have Yes or -1 in there.

the message is this . . . . .

Run-time error '3705':

Syntax error (missing operator) in query expression 'TrueWHERE tblTrackingData .[SAP #] IN(7397)'.

When I put single quotes around...

Hello,

I am new to this posting stuff, but here is my current dilema . . . .

I have a checkbox in one of my tables and I need for it to update using an update query. Now using straight Access I can just say UPDATE tblname.checkbo xfiled=Yes or even -1 and I get the good result.

The problem is I am using ome VBA coding and it doesn't seem to like the =Yes or =-1. I tried putting them in single quotes and...