Simple question, but I am new to databases. I have a field called 'ActorRetired?', and in some VBA code I need to set the value of it to -1. But When I try:
Me.ActorRetired?.Value = -1
I get the error 'Compile Error: Expected: Expression' with the question mark highlighted.
How do I refer to the field name without this error? So far I have tried
Me.[ActorRetired?].Value = -1 Me."ActorRetired?".Value = -1
But neither has worked. Please help!