Auto-generated Report

T

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.
 
S

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
[email protected]
 
Top