Report.HasData (Access)
You can use the HasData property to determine if a report is bound to an empty recordset.
The HasData property is set by Microsoft Access. The value of this property can be read only while printing or while in Print Preview. The HasData property uses the following settings.
Me!SubReportControl.Visible = Me!SubReportControl.Report.HasData