So this problem is killing me and I need some VBA help desperately. I am working in a Access 2016 environment and thought this would be easy by now. So I have a report that has all the fields (Including the ID field) from a query and a subreport on the report that connects to one of the fields on the report to pull other information for the report. I also have another page that has the same ID field that continues that report. My pickle here is that how do I export these reports as separate PDFs. Some of these reports are 2 pages. Is there a way I could group them ( I see a group function in the design view) and than export them based on the ID field. I want my output to be "ID".pdf based on the grouped IDs in the report.