Limit data in report when printing to pdf

[TimTDP]

With Access 2010, I use the following to print to pdf:

DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, FolderPath & "\" & strReportCommonName & ".pdf", False, , , acExportQualityPrint

How can I add a filter (where) to the above to limit the records in the report

If I am not printing to pdf I use:

DoCmd.OpenReport strReportName, optReportOutput, , Wclause

I need something simillar!

Thanks

 

[John Big Booty]

From here and other reading I believe that you will need to apply your filter to the Report's Record Source prior to calling DoCmd.OutputTo.