J
J Austin
Access 2007, setting a temporary variable using macros. Able to open a table
"Dates_Dataset" with OpenTable action. Able to move record pointer with
GoToRecord/Next action to proper record. Then I attempt to use SetTempVar
and give it a name Date_Quarter1_Start. Using expression builder to identify
table and field name - [Dates_Dataset]![Date_Criteria]. Get an error
message that Access cannot find name [Dates_Dataset], which I don't
understand since I was able to open this table with OpenTable.
Any suggestions as to what I'm doing wrong?
Thanks,
J Austin
"Dates_Dataset" with OpenTable action. Able to move record pointer with
GoToRecord/Next action to proper record. Then I attempt to use SetTempVar
and give it a name Date_Quarter1_Start. Using expression builder to identify
table and field name - [Dates_Dataset]![Date_Criteria]. Get an error
message that Access cannot find name [Dates_Dataset], which I don't
understand since I was able to open this table with OpenTable.
Any suggestions as to what I'm doing wrong?
Thanks,
J Austin