none
Print Dialog Box

    Question

  • Hi,

    I havde created a print button on a form using the following procedure:

    Private Sub cmdPrint_Click()
    On Error GoTo Err_cmdPrint_Click


        DoCmd.PrintOut

    Exit_cmdPrint_Click:
        Exit Sub

    Err_cmdPrint_Click:
        MsgBox Err.Description
        Resume Exit_cmdPrint_Click
       
    End Sub

    However, I would like it to call the Print Dialog Box from where users can select a printer.

    Could someone help me on this. I am using MS Access 2007.

    Thank you.

     

    Sunday, June 27, 2010 4:38 PM

Answers