SetTempVar issue

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top