Show/hide subreports

[melaniecarr23]

Is there a way to hide a subreport if no records show up in the subquery it's based on? (sort of like trim does for address fields)

I have 8 subreports, and if the dd_query doesn't apply to a patient, I want to hide it so the next subquery shows in its place.

Is there a way to do this?

Thanks!

 

[Remou]

Hi
I put this code on a subform, and it seems to work:

Private Sub Form_Current()
    If Me.RecordsetClone.RecordCount = 0 Then
        Me.Visible = False
    Else
        Me.Visible = True
    End If
End Sub

 

[melaniecarr23]

Where on the subform do you put it? My subform is dd_report. Do I actually put it somewhere on the subform or as a module?

 

[Remou]

Hi
Yes, in a module. If you look at the Properties of your subform, you should see On Current on the Events Tab. If you click the three dots and choose Code Builder, a module window should open with this in it:

Option Compare Database

Private Sub Form_Current()

End Sub

Just fill this:

    If Me.RecordsetClone.RecordCount = 0 Then
        Me.Visible = False
    Else
        Me.Visible = True
    End If

Into the the Sub. Hope that's a better explanation!