G
Guest
I have print buttons on all my forms, for easy printing for users. They all
work fine except on one form. I use the same code for all of them:
On Error GoTo Err_Command5_Click
Dim stDocName As String
stDocName = "Report Name"
DoCmd.OpenReport stDocName, acPreview
Exit_Command5_Click:
Exit Sub
Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click
On one form, based on a parameter query, when I click the print button it
asks for the parameter value again even though the correct record is already
being displayed. How do I get it to just print the record without asking for
the parameter again? Also, I need it to always print this report in landscape
mode but it defaults to portrait and I don't know how to change it.
work fine except on one form. I use the same code for all of them:
On Error GoTo Err_Command5_Click
Dim stDocName As String
stDocName = "Report Name"
DoCmd.OpenReport stDocName, acPreview
Exit_Command5_Click:
Exit Sub
Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click
On one form, based on a parameter query, when I click the print button it
asks for the parameter value again even though the correct record is already
being displayed. How do I get it to just print the record without asking for
the parameter again? Also, I need it to always print this report in landscape
mode but it defaults to portrait and I don't know how to change it.