Print report based on filter from Navigation Form

[vbbbmom]

I am using the Navigation form and I have a tab that has all the sales quotes for a particular salesperson. Because my salespeople like to work with paper I have created sub tabs which contain a report with the same information but filtered based as follows: this Month, this year, and Last year. This report needs to be printable based on the filtered information so I created a print button within the report however when clicked it prints the entire report not the filtered report.

The filter criteria is located in the navigation button, navigation where under the data properties. I have the on click event of the button set to open the report in print preview but I need to know how I filter the where in the macro to read the criteria from the active navigation button property?

Is this possible?

Any help would be greatly appreciated.

 

[Pat Hartman]

I don't use navigation forms so I'm not sure where the filter is but the OpenReport method takes a Filter argument that you can populate with the form's filter or you can use the Where argument.