Hi NeoPa,
It seems an honor, if a dubious one, to have stumped the Most Active/Most Answers member of this forum! I appreciate your offer to look over my work, and I may take you up on that but I am heading out of town tomorrow for most of this week and won't have time to prep it for you before I go.
Your comment about not having Access 2007/2010 gives me one idea to try: it turns out that I just upgraded to 2010 a few weeks...
BarksWorseThan
Last Activity: Sep 3 '12, 05:44 AM
Joined: Nov 11 '11
Location:
-
BarksWorseThan started a topic "Variable not defined"; VBA and Intellisense using outdated table schemain Access"Variable not defined"; VBA and Intellisense using outdated table schema
I can refer to some, but not all, of the fields in the RecordSource of a Form in the VBA code-behind. I have been careful to name the controls which provide data display/entry for the fields differently from the fields, and to name any variables differently from both fields and controls.
If I reference certain fields in an expression, I get a compile-time error "Variable not defined". Also, the same field names that throw... -
Sorry for the typo on your id, NeoPa...Leave a comment:
-
NeoPa -- a pleasant surprise to get a quick response! I was not really expecting much from my post here... was more interested in trying to clarify for others who may land here that the problem is real and probably NOT related (as you propose) to confusion between fields, variables, and controls.
At least in my case, I name my controls differently from the fields that are used as the control source specifically to avoid confusion when...Leave a comment:
-
I know these posts are from more than a year ago, but just want to say/clarify: I have run into this same problem, and what I notice is that the fields that are throwing the "Variable not defined" error are either fields whose names I changed recently in the table definition or new fields that I recently added to the table.
In the form design view, the Field List and the drop-down for the Control Source for a control reflect...Leave a comment:
No activity results to display
Leave a comment: