exported report name based on report fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top