Originally Posted by
June7
You have code in combobox AfterUpdate event to print report? Click, wait for report, click, wait for report, repeat 38 more times? yuck! Imagine if there were hundreds! Big yuck!
In VBA open a recordset of the desired clients. Will require filter criteria to define the desired set of clients. Loop through recordset to open filtered report, print, close.
If page numbering is not an issue and report designed for each client to start on new page, then apply the above filter criteria to report and print one long print job.