Open Print Dialog box from a Message Box

B

Beth

I created a message box prompting the user if they want to Save a
report before closing. If they click the 'Yes' button, I want to open
the Print Dialog box and, if possible, select the PDFWriter option. I
started with the DoMenuItem, but I'm having a hard time finding good
documentation on the Methods/Enumerations to select the File menu and
the Print option.

At minimum, I need to display the Print dialog box and they can pick
the PDFWriter option.

Thank you in advance for any advice.
Beth
 
A

AliH

Try . . .

docmd.openreport "reportname", acViewPreview
resp = msgbox . . . . .
if resp = vbyes
DoCmd.RunCommand acCmdPrint
else
blah blah
end if

HTH
 
Top