Access 2010 - report - dynamically change report file name
Posted on 2013-05-24
I have a report rptInvoice. When report is printed the client wants to see the invoice number in the file name in a print queue, or when he saves as PDF.
The form property caption is set to "Invoice" but in the open event I have:
me.caption=Forms!FrmInvoice!InvNo & " Invoice"
For the name in the print queue, only the report caption property is used - the vba is ignored.
So, I see "Invoice" in print queue, not "Ajax 222 Invoice" for example.
How can I change the report caption so it appears in the print queue how I want?