GroupHeader Repeat

See below. I got the answer to my original question. But when I use
"Payment History" report as a subreport then it does not work ("txtName"
starts to repeat). I coded the Main Report the same but "txtName" still
repeats.

Any help is appreciated.

Lamar wrote:


I have report named "PaymentHistory". This report has a section
"PaymentHeader" where Repeat property is set to "Yes". So this group header
repeats on the next page or column.

My problem I have a text box named "txtName" in this group header but I do
not want the txtName to repeat. txtName is what the user inputs. txtName
needs to be in the group header the first time but I want to make invisible
if the group header repeats.


The trick is to determine the first from subsequent
instances of the header. This can be done by adding a
(hidden?) text box (named txtDtlCnt) to the detail section,
set its control source to =1 and RunningSum to Over Group.

Then, in the header section format event:
Me.txtName/Visible = (Me.txtDtlCnt = 1)

--
Marsh
MVP [MS Access]