In the attached database, I’m able to export a single report to a PDF file in a specified directory. The data included in the report is dependent on what criteria is selected in my combo boxes.
When you select the zone ‘Atlantic’ in the combo box, you have a choice of two areas: ‘MD’ and ‘NJ’. First select MD, then click the [Execute] and a report will be exported to the C drive.
Instead of having to manually select each area individually to generate a report, I’m looking for a block of code that will generate a report automatically for each Area. The report would be named after the Area, and it would be exported to a sub folder named after the Zone.
So a report with the Zone ‘Atlantic’ selected and the Area ‘MD’, the file would be exported to the following path: C:\Atlantic\MD.pdf
I really appreciate any feedback. I realize this is a tough one.