Printout multiple reports with Access97

[oc2_it]

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.

[Matt Richardson]

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

For example:

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