First post ever here.
After much searching and reading, I can't seem to find a solution to what I am trying to accomplish. I currently have a combobox on a form where my users select a vendor name and then they click a button to open the report. They then review the report and click a button on a form that opens with the report that saves it as a PDF and opens up a new Outlook message with the PDF file attached (this was Lebans code for the PDF portion). The report uses a query as its source and filters based on the vendor name selected on the combobox. Once a week, the users have to make selections from the combo box and click the button each time to open the reports. The current process works, but becomes cumbersome when they have to do it for quite a few vendors.
In order to simplify this process, I want to place a listbox on the form and have them make multiple selections, then click a button and code would cycle the listbox, pass each value to the report/query, then my current code runs that opens the report, prints it as a PDF, and then opens up the email message. It would do this for each selection in the listbox.
Hopefully, all that makes sense.