Print Command Button to Another Printer

[MAPetry]

I have two print command buttons on a form. One prints to default printer the other needs to print to a different printer. Is there a line of code I can add to tell it where to print?

 

[Psychpt]

there is a very complex way to specify a specific printer. However it is not too advisable because if someone does not have that printer installed or have it installed just under a different name it won't work.
A better solution might be to bring up the print dialog box in which the user can choose one of their installed printers.

I'm not at a computer that has access on it now, but I believe the command for that is:
Docmd.RunCommand acCmdPrint

If it's wrong I'll correct it tommorrow

Hope this helps.

 

[MAPetry]

I tried the command and it works to print the form. I guess I should have specified that I am printing a report for the current record. This is the code for my other report that prints the current record only to the default printer.
I need to print the RptFaxCover to another printer for the current record only. I tried adding the acCmdPrint and could not get it to work. Any suggestions.
Thanks for your help


Private Sub PrtFaxCover_Click()
Me.Refresh
Dim strReportName As String
Dim strWhere As String

strReportName = "RptFaxCover"
strWhere = "[FAXID]=" & Me!FAXID
DoCmd.OpenReport strReportName, acNormal, , strWhere

End Sub