Need to include filename in the destination path. What do you want each report to be named? If you don't assign a unique name to each report, it will overwrite existing. Does your current code overwrite? If it does, what is purpose of saving to PDF?

Where do you get acCmdSelectRecord from? AFAIK, that is not an option with OutputTo.

Apply filter to form or report if you don't want all records to output.

Review https://learn.microsoft.com/en-us/of...docmd.outputto

You said does not work correctly when you use a report - why? Really should use report.