Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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!
You can't have special characters in a VBA name. The bang operator ( the ! in Me![ActorRetired?] = -1) is just a shortcut for string based name lookup. It's not syntactically clear so I recommend using an actual string so it's clear that is what you want to do.
If you want to access the underlying Field using a string you would go through the form recordset like this:
Me.Recordset.Fields.Item("ActorRetired?").Value = -1
Or if you have a control of the same name you can go through the forms control collection like this:
Me.Controls.Item("ActorRetired?").Value = -1
Me.ActorRetired_.value. But I'd recommend you to rename your control/column to some name which does not contain problematic chars, for example, toDoesActionRetired.Me.- intellisense will suggest all possible variants, look in the list for your column name as it is interpreted by VBA. When I create a table with the column namedActorRetired?, then create a form with this table as a rowsource using master, and then try to refer to the column's value in Form_Current - shown expression works correctly. So describe detailed what do you do...Me![ActorRetired?] = -1- it's been a good long while since I used Access, but I remember something along those lines for fields that aren't directly added as an object to the form.