How do I dynamically set the Outputfile in the OutputTo method?

G

Guest

I want to save a report with a name that changes based on the school name. In
the OutputTo method, I have tried setting the Outputfile name
"[Forms]![Dialog - EMail AD Report]![Selection]" & " AD Report.rtf" in hopes
of getting "Arts AD Report" or "Academy AD Report" where Arts and Academy are
two different school names. I am running one report at a time. The report
contents get output OK, but the name is literally "[Forms]![Dialog - EMail AD
Report]![Selection].AD Report.rtf".

Is there a way I can have the file name changfed based on the school name
changing?
 
G

Guest

Leave the form information outside the quotes:
[Forms]![Dialog - EMail AD Report]![Selection] & " AD Report.rtf"
 

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

OutputTo PDF error 2501 The OutputTo action was cancelled 1
OutputTo pdf error 1
User cancels Dialog Box in OutputTo method 2
Filtering a report used with OutPutTo Method 5
OpenReport method with a Form criteria 7
OutputTo Excel File Name 2
Copy worksheets and save files dynamically 3
Prevent selecting filtered rows in AutoFiltered Range 4

Top