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?

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

> 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?