[RESOLVED] VBA Printing from access

[Strider]

im using the following code to print the current record of the form


i was wondering if it is possible to specify in it which printer you would like to print to or display the print dialog even


Private Sub Print_Record_Click()
On Error GoTo Err_Print_Record_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection

Exit_Print_Record_Click:
Exit Sub

Err_Print_Record_Click:
MsgBox Err.Description
Resume Exit_Print_Record_Click

End Sub

[RobDog888]

Here is how you can set a specific report to use a specific printer.
Dim oReport As Report
DoCmd.OpenReport "Report1", acViewPreview, , , acWindowNormal
Set oReport = Application.Reports("Report1")
Set oReport.Printer = Application.Printers(0) 'Change to printer index you desire.
DoCmd.PrintOut acSelection

[Strider]

will that work for printing forms or just access reports

also how is it possible just called the print dialog from the file->print menu