show/hide SubReport

[Guest]

Hi all,

Is it possible to have a subreport show/hide based on a checkbox selection?
I have a form with the following event:

Private Sub PercentRent_AfterUpdate()
'After Update of checkbox
'Check if Percentage Rent checkbox is selected
'then show or hide subform
If Me.PercentRent = True Then
Me.frmPercentRent.Visible = True
Else
Me.frmPercentRent.Visible = False
End If

Can I do something like this on the report?

Thanks

 

[Marshall Barton]

Is it possible to have a subreport show/hide based on a checkbox selection?
I have a form with the following event:

Private Sub PercentRent_AfterUpdate()
'After Update of checkbox
'Check if Percentage Rent checkbox is selected
'then show or hide subform
If Me.PercentRent = True Then
Me.frmPercentRent.Visible = True
Else
Me.frmPercentRent.Visible = False
End If

Can I do something like this on the report?

No. Report's are static objects that do not support
interactive components the way forms do.

The usual usual thing to do is use a form for users to
select report options (such as your check box) and the set
the appropriate properties in the report's Open event:

Sub Report_Open( . . .
If Forms!theform.PercentRent = True Then
Me.frmPercentRent.Visible = True
Else
Me.frmPercentRent.Visible = False
End If
End Sub

 

[Guest]

Thanks Marshall. It was a just a thought.

No. Report's are static objects that do not support
interactive components the way forms do.

The usual usual thing to do is use a form for users to
select report options (such as your check box) and the set
the appropriate properties in the report's Open event:

Sub Report_Open( . . .
If Forms!theform.PercentRent = True Then
Me.frmPercentRent.Visible = True
Else
Me.frmPercentRent.Visible = False
End If
End Sub