Variable Macro

mikemaki

Registered User.
Local time
Today, 14:36
Joined
Mar 1, 2001
Messages
81
I have one form with numerous buttons, each to print a specific report. I wrote an OutputTo Macro for use on a toolbar to export the open report to Word. I store the report name in a hidden text box on the Main Screen. Can I use variable such as this in a Macro? Right now my object name field is [Forms]![frmMainScreen]![ReportName] and I being told this report doesn't exist. Do I need a different syntax?
 
Last edited:
For anyone wondering, I needed to add an = to the variable name. The report exports to the correct file now. But the checkboxes from the access report don't show up. Any ideas how I can handle that?
 

Users who are viewing this thread

Back
Top Bottom