Add double message boxes

[daniels012]

Can I have a message box come up and ask do you want to print now.
If yes print report "RptWorkOrder" if no CANCEL PRINT

If it is Yes then print the form and I want another message box to appear. I want it to say "Enter white paper in printer then hit OK" When they hit OK it would then print.

Can anyone help me with code I can attach to a print button.

Thank You very much,
Michael

 

[apr pillai]

I hope this will help.

Private Sub cmdPrint_Click()
If MsgBox("Do You want to Print the Report...?", vbYesNo + vbDefaultButton2 + vbQuestion, "Print Report") = vbYes Then
     MsgBox "Load White Paper on Printer and Hit OK"
        DoCmd.OpenReport "myReport", acViewPreview
End If

End Sub