access sub-report conditionally hiding
Posted on 2014-02-13
I have a (2010) report with multiple sub-reports, all bound to queries, and wish to hide them (and set their height to 1) if the particular report has no data.
I was considering using a recordcount property on the 'open' (sub-report) event to do this but apparently this property is accessible in adp.
What properties, on what event, would I use to ascertain recordcount and set properties?
Please provide a code snippet e.g.
Private Sub Report_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
Me.Height = 1
Me.Visible = False