Requery and Print Reports?

[Kevo]

Hi All,



TGIF!


Here is what I want to do:

When user closes database by closing Main Menu (splashscreen)....on close event will do the following:


MsgBox "Would you like to print End of Day reports?" Yes/No

If Yes then

Print reports ( 2 reports that each have a different query as recordsource)

Close application

Else

Close application


So, my questions are:
-Can a MsgBox trigger the next action? If so how.
-The queries that are the recordsource of the reports I want to print have criteria that is driven by "dates" that are on a form. Can the query look at the "dates" even though the form isn't open? (keep in mind that the default value for these "dates" are already set to Date() which is what I want for the end of day report.

-Lastly, I am not strong in VBA (ok, make that pretty much clueless) so, any help with this code would be greatly appreciated!


Kevo

[Kevo]

BTW,

Here is what I have tried so far....not much luck.

Private Sub Form_Close()
MsgBox "Print End of Day Reports?", vbYesNoCancel
If VbMsgBoxResult.vbYes Then
DoCmd.OpenReport "rptBILog", acViewNormal
DoCmd.OpenReport "rptLoadDetails", acViewNormal
DoCmd.CloseDatabase
Else
If VbMsgBoxResult.vbNo Then
DoCmd.CloseDatabase
Else
DoCmd.CancelEvent
End If
End If
End Sub

One problem is as I suspected....it is asking for the criteria from the form that isn't open. Would you open query, print report, then close query? Seems like there is any easier way.