Add button to navigation form header to print displayed report

[Slush]

Hello,



I am using a navigation form to display reports. I would like to add a command button to the navigation form header which would print the report currently displayed on the form. Ideally it would open the selected report in print preview or bring up the option to select the printer and printer settings. I know how to add buttons to each report to do this, but I would like to have one button in the header of the form rather than a button on each report. I tried the solution described in the link below, but I could not get it to work.

Suggestions?

https://www.experts-exchange.com/que...cess-2010.html

[pbaldy]

Sounds like this should work:

http://www.baldyweb.com/wherecondition.htm

[Slush]

Sorry. I don't get it. The navigation form will have buttons along the side which will display different reports. In the header I want to have a button which opens a print preview of the report currently displayed in the navigation form.

Code from the link provided:
DoCmd.OpenReport "SecondReportName", , , "FieldName = " & Me.ControlName

expression .OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

The "ReportName" is determined based on the report currently displayed. How do I indicate the name of the report when it will be determined based on the report currently displayed which can change?

[pbaldy]

Sorry, I misread that as printing the record currently displayed. Behind the buttons that display reports, you could add code to set a public variable, TempVar or form control to the name of the report, then use that in your code.