Printing in 'batch' mode

[iansl2000]

Hello,
I have a database in which users enter purchase order details. Each order receives a unique number.
Instead of the users then printing out each order I would like to run a macro or vba routine that prints all orders entered that day, at teh end of the day.
I'm guessing that I will have to loop through a recordset of some kind, to print each order.
Can anyone point me in the direction of some help on this?

Thanks in advance for any help
Ian

 

[gemma-the-husky]

no, you should just need to create a query with all the records, and print the query with appropriate sorting and grouping

its just like any other report - just get it to do a new page after each group footer - ie each new order

 

[iansl2000]

Doohh!
of course!
Such a simple solution - when someone tells you.
Many thanks
ian