Action after printing

[Stuart Green]

I have a report that I want users to preview. They can then choose to print it. If they do print it I then want a piece of code to run asking if they want to run an update query. (records that the letter has been generated). I have tried tying this in to OnPrint in the report footer but no joy so it is obviously the wrong option. Any suggestions would be most grateful

 

[llkhoutx]

This is difficult to code because closing a report is not an event you can trap.

When printing the report, try generating the message and options in a form which is opened and then print on top of that form. When the report is closed, the form with the message will be visible and active.


docmd.openform "YourformWithMessage"
docmd.openreport "YourReport",acPreview

This works because code does not stop running merely because a form or report is opened.

 

[Stuart Green]

Nice solution, gave me just what I wanted. Many thanks for the help