I have a report that loses it's group count. In the Group Header there are two TextBoxes, "txtMfg" which is bound to and shows the names of manufactures in the table named "tMfg", the second TextBox named "txtMfgCount1" counts the number of times "txtMfg' changes in the (Mfg Group), and it's property settings are "=1" in it's Control Source and the Running Sum set to "Over All". I have also set Running Sum to "Over Group" and got the same results.
In the Report Footer I have a TextBox "txtMCount1" with it's Control Source at "=[txtMfgCount1]" which shows the number of times "txtMfg" has changed in the Report.
When the Report is opened in Report View, the Report Footer, "txtMCount1" shows a number of "8" which is the right number.
The problem is when I go to Print Preview the textbox "txtMCount1" shows a number of "1" not the expected number of "8".
Has anyone ever had this happen, if so how did you fix it.