Printout multiple reports with Access97

For each record of a table I have to printout 2 different report but creating 1 print preview (and 1 print queue).

Example :
record 1 printout report #1 and then report #2
record 2 printout report #1 and then report #2
record 3 ......


Thanks.

you have to loop through the records, and call the docmd.openreport method for each record twice.

For example:

Code:

---

While Not lobjData.EOF
    'preview the report
    DoCmd.OpenReport lobjData![ReportName], acViewPreview
    'print the report
    DoCmd.OpenReport lobjData![ReportName], acViewNormal
    lobjData.Movenext
Wend

---