Change Access Report name based on field

[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?

 

[Duane Hookom]

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