Hide Parent Detail.

[skea]

I have a sub Report in the detail section of its parent. I need to hide the detail part of the parent if the subReport corresponding to the record has no data.
Here is what iam trying to do but failing, any ideas...

Private Sub Report_NoData(Cancel As Integer)
Me.Parent.Section(0).Visible = False
End Sub

 

[neileg]

I would try to exclude the parent record from the data that the report is based on rather than manipulate the report.

 

[skea]

Thanks neileg.
The problem is that the two reports have different record sources although linked by an ID.

 

[neileg]

If you do an inner join on the two record sources on the ID, it will only return the parents that have children.