Printing report from Navigation Subform

Flag

New member
Local time
Today, 10:32
Joined
Mar 7, 2017
Messages
8
I am using Access 2017 and have built an DB using Navigation Forms, horizontal tabs and vertical tabs left. Main form is named 'Home' with default subform name of Navigation Subform. I can print a report straight to the default printer. I can show a print preview of a report in the Navigation Subform. However, how do I then print the report to the printer. A print command button placed in the report header does not show in print preview but does show in layout mode. Layout is not available when you run the DB! The print ribbon, of course is not available in navigation forms. Any help would be appreciated.

Solved it. On the vertical tab used to open the report in report view

Private Sub PrintSignupRepBut_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewReport
End Sub

Then on the print button on the report I used:

Private Sub PrintButtonOnReport_Click()
DoCmd.OpenReport "LTSwimSignupFormReport", acViewNormal
End Sub

Seems to work fine and is a simple solution.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom