I really hate subreports. They don't work well half the time and you miss out on cool formatting tricks. Use a query. Join together the records from your parent and subreports into one recordsource. Same technique I use to create invoices in Access Expert 9, which I see you have.

The reason I'm using subreports is because I'm trying to replicate a real report that has 4 parts and a specific format order. For example, the 1st part is about the customer (contains 5 textbox about the customer), 2nd part is about emergency contact info (with five text boxes that describe it: name, address, phone number...). If the customer has 5 emergency contact the 2nd part of the report must show 25 text boxes vertically (two columns, title on the left, data on the right), 5 text boxes for each customer. Part 3 and 4 of the report are similar to part 2. The report needs to show all 4 parts in one continuous report, like a 5 page report. If there is another way of creating this report please shed me some light? Thanks in advance.

I'm sure there's a way. Let me experiment. I know there are options to break groups up. Not sure about inside of subreports though. I almost never use them.

Thanks Richard! I tried this and it worked for me. Here is the link: Subreports and Page Breaks

OK excellent. I'm glad you found a solution. I actually did put this on my list of things to look at. It's in my TechHelp queue. I know I've done this before, but I don't know it well enough to just quote off the top of my head because I really don't do a lot with subreports. I try not to use them.

I highly recommend Mr. Excel, by the way. He's awesome. I consider myself an Excel expert. Bill Jelen is The Master of Excel. He is to Excel what I am to Access. Access is my forte and I just happen to teach Excel too. Bill is the Excel guru.