When Closing Report message to ask "Would you like to save this report?"

[MFS]

Good morning,
I'm looking to have an option box appear whenever I close a report asking "Would you like to save this report?".
If YES is clicked I then need a prompt for location. I would also like to format as a .pdf.
If NO is selected then the report simply closes.



Is this easily obtainable?

Speck

[CJ_London]

I then need a prompt for location

- google 'filedialog' for a variety of possible solutions. The option you will probably require is msoFileDialogSaveAs

I would also like to format as a .pdf.

google 'docmd.outputto' to find how to do this

[June7]

As Ajax suggests, the OutputTo method can save report as PDF. And if you want to allow user to specify the destination, use FileDialog.

Both are common topics in forum.

[sstiebinger]

and if no simply DoCmd.Close

[June7]

Attempt code and when you encounter issue, post specific question.