printing records from multiple forms and collating the forms

[lakeshore]

I trying to print a record that is pulling the data together from multiple forms. I have set up a macro that will print form1,form2, form3, etc. If there are ten records that I want to print, the macro will print form1 ten times, then form2 ten times and so on. I would like to have the records collated when printing.
Is there a solution in an Access Macro or Visual Basic?
[sig][/sig]