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?