help with printing duplex

[ahau]

Hi,

I have a question related to duplex and wonder if anyone might be able to help me.

In a form, there is a checkbox with label "duplex" called CK_Duplex. User can choose to have duplex checked or unchecked.

the following is the code for the report.
Private Sub Report_Open(Cancel As Integer)
If Forms![Outline_Selection].CK_Duplex = True Then
MsgBox "Duplex is on"
Me.Printer.Duplex = acPRDPHorizontal
Else
MsgBox "Duplex is off"
End If

DoCmd.Maximize
End Sub

This works great because it prints the report double side when the duplex is checked. My question is how to unset the duplex if the user decided to only print a single side report by unchecking the duplex checkbox. Is there a way of controlling the printer thru access?

Thank you in advance

 

[ahau]

Sorry it's been fixed already.

Thank you