I have an Access report linked to records in a query. I currently print one report (to file as a PDF) at a time by filtering by an id number, but have thousands of reports to print and save. I am looking for code or macro instructions to print one report at a time (I now have Adobe Acrobat 9 Pro available, but am willing to try anything, eg CutePDF, PDF Creator) and save each report with a unique file name that is specified in a separate field but in the same record within the source query. I need to print one report for every record in the query. I also need to specify the filepath where all the reports will be saved, but that can be the same for all the reports.

Would be grateful for any help, suggestions, references, etc.