Printing multiple reports with one command

[AKQTS]

I have a program with orders and batches

One order = multiple batches

The reports are generate from the batch numbers because I have subreports and different logic statements allowing visibility to turn on or off so when I query up my report it is only the current batch selected.

When I click the print button I need it to print the report for all batches of the same order.



What command can I use to get this to cycle and print out each batch report for an entire order with one button click?

If you cannot tell I am lost on this one.

Thanks!

[NTC]

A macro comes in handy for this. You can set up a macro to OpenReport - and default it to be print (rather than preview) and just repeat that for each report you have.

Save & close that macro with a name....and then make a button and option it to run that macro.

[AKQTS]

That is what I have done in the past, but what I am trying to do is loop through all of my batch record reports. I am needing help on writing VB to starting printing at batch 1 for an order and print through Max(batch number). Some orders have one batch, some orders have 10, some have 3......