Report Name

[Gismo]

Hi All,

Is it possible to have a report name based on a value in a form?
Every time the value changes in the form, the report name should change as I export to PDF and would like to have the report name for each export to be unique

 

[theDBguy]

Hi. I hope you don’t really mean you want to change the name of the report and just the name of the PDF file when you export the report. If you really want to change the name of the report, you could try using DoCmd.Rename.

 

[Gismo]

yes only the PDF file name will do.

How will I use DoCmd.Rename to select the record selected on a form?

 

[theDBguy]

Hi. You don’t need DoCmd.Rename any more. Instead, you can use DoCmd.OutputTo and just specify the filename in the argument.

 

[Gismo]

I is not possible to rename the Output PDF automatically to a value in a specific form which was selected?

 

[theDBguy]

Hmm, not in front of a computer now, but doesn’t the OutputTo method have an argument for the filename? If so, you should be able to specify the name of the PDF file. Can you post your OutputTo code, so we can tell how we can modify it? Thanks.

 

[Gasman]

I is not possible to rename the Output PDF automatically to a value in a specific form which was selected?

Of course it is

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.outputto