Change Access Report name based on field

  • Thread starter Thread starter Rhonda
  • Start date Start date
R

Rhonda

I currently have a report that runs an invoice for all clients and
prints to Acrobat Adobe and creates a .pdf file named as the Report
name (PhysicalAuditInvoice). This report then contains every invoice.
To create individual .pdf files for each client, I have to run the
report filtered for each client, print it to the .pdf file, then
rename it.

I am wanting to automate that so that I can run a macro or something
that will create individual report files, named according to the
client number and the current date (like
0005_PhysicalAuditInvoice_091704).

Anyone have any idea on what direction to start with this?
 
I'm not sure it this will work but you could try change the Caption property
of the report in the On Open event.
Me.Caption = Forms!frmA!txtClient
 
Back
Top