Multiple reports for 1 record

[sucoyant]

Hello all!

How would I go about printing multiple reports for 1 record?

Right now, the code I have is this:

DoCmd.OpenReport "Minnesota Letter", acViewPreview
DoCmd.OpenReport "Minnesota Letter Cont", acViewPreview

But that will print "Minnesota Letter" first entirely, then print "Minnesota Letter Cont" once.

What I need it to do is print the "Minnesota Letter", then print "Minnesota Letter Cont" for each record, in a loop, untill the end is reached.

Thanks in advance!

________________________________________

Buddha. Dharma. Sangha.

 

[GoDawgs]

Can you put the "Cont" report into the other report as a sub-report? That way it's all in one...

 

[sucoyant]

The report right now is maxed out for length. It needs to be 4 pages long.

I don't know much about subreports... could you please elaborate?

________________________________________

Buddha. Dharma. Sangha.