nonblocking VBA call?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top