Access2K - Multi selection for printing - TechRepublic
General discussion
February 23, 2003 at 10:34 AM
richtee

Access2K – Multi selection for printing

by richtee . Updated 23 years, 3 months ago

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.

This discussion is locked

All Comments