nonblocking VBA call?

  • Thread starter Thread starter gregg durishan
  • Start date Start date
G

gregg durishan

I'm attempting to have a yes/no messagebox appear after
someone closes a report that asks if they wish to print
the report to PDF. To print the just-displayed report, it
needs to be closed, then opened in print mode. I put the
messagebox in the onclose event of the report, and it
calls a vba function in it's corresponding dialog form to
then reopen in print mode and all the other tasks that
get it to print to PDF. Problem is, the report blocks and
waits on the call to the dialog form's function, and
doesn't exit until it returns. Therefore I can't open it
in print mode because it's still open in display mode. If
only the call wouldn't block, the report would then
close, and I'd be free to print it.
Anyone have any advice on how I should accomplish this?

-g
 
Back
Top