it's late (or i'm losing my mind)

[_Bigred]

how do I set a macro to print out 4-5 reports when I close a particular
form?

I am using access 2000.

TIA,
_Bigred

 

[Steve Schapel]

Bigred,

You can make a macro with a series of OpenReport actions, one for each
of the reports you want to pring, and then assign this macro on the
Close event of the form. Is that what you mean?

 

[_Bigred]

Is there anyway to prompt the user yes or no to the printing function? (In
case they open the database but don't need to automatically print all the
reports).

Or should I go with a button seperate button, instead of using it tied to
the on close event?

Thanks,
_Bigred

 

[Steve Schapel]

Bigred,

You can use a MsgBox function in the Condition of the OpenReport action
in the macro. For example, if you put like this...
MsgBox("Print report?",36,"Confirm")=6
then the report will only be printed if the user clicks Yes.