Auto-generated Report

[Timothy Millar]

I have a form with a command button. If the EndUser clicks the button a
report [rptUTILITIES] is generated and saved to the hard drive and the
EndUser moves to the next form without even knowing the report was generated
and saved.

How would I code this?

Let me thank you ahead of time. Thank you.

 

[Steve]

Hello Tim,

Look in the Click event of the button. There's a line of code to save the
report and then a line of code that looks like: DoCmd.OpenForm
"NameOfNextForm". Add the following code between these two lines of code:

MsgBox "The Utilities Report has been saved to the harddrive"

Steve
(e-mail address removed)