I have an access 97 report that must be closed as the table it is based on must be deleted. However, I would like an input box to appear asking if they want to save the report.

Therefore, I would like to (In code) publish it to word and save it.

Any thoughts?