How do I print specific report with PrintObject in Macro

[abzalali]

Dear Expert,
Actually I need to select printer before printing report. That's why I need to call printer dialog to select printer using "PrintObject" in macro. But it's print the form not report. I need to print a specific report. How can I do this?

Please help me.

Thanks
Mir

 

[abzalali]

It is now working with this code:

On Error GoTo CmdPrint_Click_Error
        DoCmd.OpenReport "rptECN", acViewPreview, , , acHidden
        DoCmd.SelectObject acReport, "rptECN"
        DoCmd.RunCommand acCmdPrint
        DoCmd.Close acReport, "rptECN"
    Exit Sub
CmdPrint_Click_Error:
          DoCmd.Close acReport, "rptECN"
          If Err.Number = 2501 Then
            Err.Clear
          Else
            MsgBox "Error " & Err.Number & " (" & Err.Description & ")"
          End If

But report window comes behind printer dialog as new tab
How do I hide this window? Please help me.