Sub Report with No data

[RayMilhon]

I have an Access 2010 Report that contains 2 sub reports. Each Detail line may populate 0,1 or both of the subreports. I have each Subreport set to can Grow, Can shrink set to Yes. I want the subreport label to only be visible when the subreport contains data. In the subreport No Data How do I reference the main report label for that subreport so I can set visible = false????

[boblarson]

Actually, in the On Format event of the section on the main report you would want to do the check:

Me.LabelNameHere.Visible = (Me.SubReportControlName.Report.HasData)

[RayMilhon]

This is what I put in but I get the error Message Method or data member not found
What am I missing? I typed hasdata Access changed it to HasData but I still get the error message????

Me.Previous_Admits_Label.Visible = Me.Previous_Admits.HasData
Me.Cases_Label.Visible = Me.Cases.HasData

[boblarson]

This is what I put in but I get the error Message Method or data member not found
What am I missing? I typed hasdata Access changed it to HasData but I still get the error message????

Me.Previous_Admits_Label.Visible = Me.Previous_Admits.HasData
Me.Cases_Label.Visible = Me.Cases.HasData

Nope, you aren't using it correctly. Remember you need to refer to the subreport CONTROL (control on the parent report which HOUSES the subreport and is not the subreport itself unless they are named exactly the same). And you need to add the .Report. part.

So - if your subreport control name is actually Previous_Admits and not Previous_Admits subreport (same with cases), it would be:

Me.Previous_Admits_Label.Visible = Me.Previous_Admits.Report.HasData
Me.Cases_Label.Visible = Me.Cases.Report.HasData

But if it is the other then:

Me.Previous_Admits_Label.Visible = Me.[Previous_Admits subreport].Report.HasData
Me.Cases_Label.Visible = Me.[Cases subreport].Report.HasData

[RayMilhon]

Thank you Bob You're a great help as always