Alternate Subreports?

[MrMeric]

Good day!

I have a report that has the following layout:

+----------------------+
| subreport1 |
|-----[Page Break]-----|
| subreport2 |
|-----[Page Break]-----|
| subreport3 |
|-----[Page Break]-----|
| subreport4 |
+----------------------+

Is it possible to alternate subreports for each record?
For example, for each record I would like to print subreport 1-4, then move to the next record and repeat.

Is this possible?

Many thanks!

 

[dhookom]

It is difficult to understand what you want. I would expect that you can use a record source on your main report that can be linked to each subreport with Link Master/Child properties. Remove the pagebreaks from between the subreports if necessary.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.