exported report name based on report fields?

[Guest]

Is it possible to pass the values of fields within the report in naming the
report for my outputto saving option?

I would like to include my invoicenumber and orderdate on the reportname?

Any ideas? suggestions?

Thanks,

Brook

 

[Guest]

create something like this:

DoCmd.OutputTo acOutputQuery, _
"MyReport", _
acFormatXLS, _
"MyReport-Invoice_" & Forms!parameters_frm!invoice &
"_Order_Date_" & Forms!parameters_frm!orderdate & ".xls"

change the paramenters_frm with your form sending the parameters to the query