Show Count of Subheaders in it's Parent Header Section

[DaveInIowa]

Is there any way to get a count of the number of subheaders and place this count in it's associated parent header section? If I use COUNT(*), I get a count of the detail lines. I've also tried creating a dummy txtOne field in the subheader (with Control Source =1) and attempting to display the count as COUNT([txtOne]) but this keeps asking me to enter a parameter value for txtOne.

 

[Remou]

Hi
For what its worth:

Option Compare Database
Dim CountHdr0
Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
CountHdr0 = CountHdr0 + 1
End Sub

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.txtCountHdr = CountHdr0 / 2
End Sub