Just figured out there was a problem following these steps when a sort criteria already exists in the sort list. If this is the case for you, follow the steps as suggested here, then:
- select the group row from the "Sorting and Grouping" popup box
- drag it and drop it to the top of the list

This will prevent the header appearing before every group of rows sorted by the preceding criteria.

This works beautifully! Thanks!

my subreport uses columns how do i use the fix?

You're a God send.

Thanks a million

Peter
Lynwood
Western Australia

also does any one have a decent way of making the microsoft access application window disappear when the database loads, so that the database looks like a professional stand alone application when used? i downloaded some code that someone created as a module to do this, but there must be a better way?
Thanks in advance my little geniuses!!!

Wow, you just saved me a lot of time and a big headache!

15 years access experience and only just hit this issue - and on the most important reports I've ever needed to produce! Thanks a million!

Thanks a lot for your important contribution - kudos.

Thanks for documenting this solution in an easy problem/solution format.  I might not remember this solution next time I need it, but just know it exists make me feel so good! 

Thanks so much. Solved a minor headache for me and once again beats the pants off of MSFT's solution.

Thanks for the tip

Great write up! Thanks!!!

Thanks a Million, no need to scratch head for the access script just to get repeated page header to the other side..since im creating a 2 side data into 1 page...

Thanks muah muahh (^ _ ^)/
http://allaboutads-makemoney.blogspot.com

Awesome , this worked!

Just figured out there was a problem following these steps when a sort criteria already exists in the sort list. If this is the case for you, follow the steps as suggested here, then:
- select the group row from the "Sorting and Grouping" popup box
- drag it and drop it to the top of the list

This will prevent the header appearing before every group of rows sorted by the preceding criteria.

The best way to handle this is to force a new page after a set number of records have printed. I have done this and it works.

The first step is to create a few formulas to keep track of your record counts.

//@reset_var
whileprintingrecords;
numberVar record_cnt := 0;

Place the above in your group header in the subreport. We want to reset the variable every time the group header prints.

Next, create this formula to increment the counter for each record, and place the formual in your details section:

//@increment_var
whileprintingrecords;
numberVar record_cnt := record_cnt + 1;

Now, the next step is to determine who many records comfortably fit on one page.
Once you have determined that, go to Format, Section.
Highlight details, and click the X+2 button next to the New Page After property.
In the formula editor that opens and this line:

{@increment_var} = 20 // replace 20 with the number of records that fits you report

You also must make sure that you have the "Repeat Group Header on each page" option set.

Give it a try. Let me know if you have anyother issues with it.

The problem is that your fakeheader is actually a group header. You can't force a group header to print before a page footer because if the combined group header/footer exceeded the length of a page then you'd be caught in an endless loop.

I believe you've just run into a limitation of the workaround and AFAIK there's no way to correct this.

My question may be silly, but please help as my school assignment's deadline coming up. I'm using MS Access 2007 and can't find the place to set the "Field/expression" and Repeat Section field. Please helppppp

THANKS HEAPS
Yes, I got it - Wow! you can answere any questions of us. You are my angle.