Access 2000.
I have a combo box [cboInvoiceNum] on a form that gets populated based on the selection in another combo box.
There can be anywhere from 60 to 100 numeric values listed in [cboInvoiceNum].
I can select any item listed, click the print command control, and the selected value is used as the variable to run a query (DoCmd.RunSQL code), which creates the source for a report.
Here is where I need help ? I need the code to create another print command that will loop through allthe items in the [cboInvoiceNum] and run the report for each item.
Any help with a For-Next, Do-While, etc, or whatever works code would be greatly appreciated. Thanks.