I have 4 reports that print out when a macro runs. If there are 10 records that each of these reports is based on, how can I get them to collate rather than print 10 pages of 1 report, 10 pages of the next, etc.
Build an appropriate query which gives you one record at a time, cycle through all reports, then query for the next record, cycle through all reports, etc.
There is an article that addresses this issue. Go to http://search.support.microsoft.com. Enter Access 2000 into 1). Select Specific Article ID Number for 2). Type Q231805 into 3). You will get an article titled Using Visual Basic Code to Collate and Print Two Reports.