Have second command wait for first to end

[SAC]

In code I want to print a report and then email it, but the email code
starts to run before I can finish printing the report to a file.

I have docmd.OpenReport......

Then I have docmd emailReport....

Can I put something in there to have the email line wait...

Thanks.

 

[Guest]

Hi, SAC.

How about:

MsgBox "Press OK to email completed report."

Sprinks

 

[SAC]

That's too easy!!!!

Thanks.

Hi, SAC.

How about:

MsgBox "Press OK to email completed report."

Sprinks

 

[James Arnold]

May also want to try:
DoEvents

That's too easy!!!!

Thanks.