Pause form execution while report is open

[Brian]

Age-old problem here. I have a button on a form that needs to accomplish 3
things:

1. Open a report (acPreview)
2. Allow the user to print the report if desired
3. Ask the user if he wants to post the records

Problem1: code on the form from which the report is called continues to run
when the report opens
Problem2: classic solution - acDialog - does not let user access my custom
menu bar that has the print icon on it while the report is open
Problem3: ctrl-P, although it allows printing of report open in acDialog,
seems a little tacky
Problem4: acDialog in conjunction with Report_Close, while it could be used to
bring up a print dialog on close of the report, also seems tacky
Problem5: turning modal off doesn't help, because I need to pop up the
MsgBox asking if the user want to post the records after the report closes

In short, I need to allow printing while the report is open in Preview, but
pop up an If (MsgBox...) when the report is closed and pass the result back
to the form for processing.

 

[Albert D. Kallal]

Problem1: code on the form from which the report is called continues to

run
when the report opens
Problem2: classic solution - acDialog - does not let user access my custom
menu bar that has the print icon on it while the report is open
Problem3: ctrl-P, although it allows printing of report open in acDialog,
seems a little tacky
Problem4: acDialog in conjunction with Report_Close, while it could be
used to
bring up a print dialog on close of the report, also seems tacky
Problem5: turning modal off doesn't help, because I need to pop up the
MsgBox asking if the user want to post the records after the report closes

In short, I need to allow printing while the report is open in Preview,
but
pop up an If (MsgBox...) when the report is closed and pass the result
back
to the form for processing.

Why not just have code in the reports on-close event call the code in the
form?


Call forms!nameOfForm.MyPublicsubName

 

[Brian]

Too simple! I knew I was overlooking something simple. I was too focused on
having the posting code following the report-opening code (and in the same
procedure).

Thanks.