I used to do this:

DoCmd.OpenReport stDocName, acViewPreview, , mfilter2
DoCmd.RunCommand acCmdPrint
DoCmd.Close acReport, stDocName, acSavePrompt


Someone suggested I use the outputto method, so I changed it to this: and now the mfilter2 which had some parameters in it doesn't seem to have a place in the output2 method.

sOutputFileName = pathname & "\" & stDocNumber & "\" & stDocName & sFileNameSuffix
DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, sOutputFileName, False

So consequently the wrong report is being put to PDF.

Any ideas?

THAT WORKS!!!! Thank you sooooo much! I didn't realize I was replacing only 1 statement and I could keep the rest. This makes my day!