SetTempVar issue

  • Thread starter Thread starter J Austin
  • Start date Start date
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
 
Back
Top