Hello,
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
Right now, my code looks like this for On_Click:
But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code:
ABC Co.
ZYX Co.
123 Co.
Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.
Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If