Switchboard

[Paul Agliano]

I am trying to make a print button on the switchboard itself to print a report. Instead of it being printed from the form page. Is it possible to print from the switchboard directly. If so can you please help me.

Thanks in advance for your help and time.

Paul

 

[BLeslie88]

Would this not work?

Make a command button, go to click event and type this...

Private Sub cmdRpt_Click()
On Error GoTo Err_cmdRpt_Click

Dim stDocName As String
stDocName = "rptName"
DoCmd.OpenReport stDocName, acViewPreview
DoCmd.Maximize

Exit_cmdRpt_Click:
Exit Sub

Err_cmdRpt_Click:
MsgBox Err.Description
Resume Exit_cmdRpt_Click
End Sub

Regards,

 

[Peter D]

Yes, OpenReport should be an option from your switchboard.

Open your switchboard and click "Change Switchboard Items". Add a new item, and select OpenReport for the new item's action.


Hope this helps,