<div>
Put the label on the main report behind the subreport and use this code: <br />
Private Sub Report_NoData(Cancel As Integer)<br />
&nbsp; &nbsp; Me.Parent.lblNNC.Visible = True<br />
&nbsp; &nbsp; Me.Visible = False <br />
End Sub
</div>


Put the label on the main report behind the subreport and use this code:
Private Sub Report_NoData(Cancel As Integer)
    Me.Parent.lblNNC.Visible = True
    Me.Visible = False
End Sub

<div>
<div class="content wysiwyg-content">
I have a report that contains a subreport. &nbsp;When the subreport does not have any data to display I would like a label to appear with a message saying &quot;No New Clients&quot;. &nbsp;I have the label on the subreport with the visible property set to false. &nbsp;I also have the below code. &nbsp;This works when I run the subreport separately, but when I run it with the main report it does not work. &nbsp;Any suggestions?<br />

<pre><code id="code-365864">Private Sub Report_NoData(Cancel As Integer)
    Me.lblNNC.Visible = True
End Sub
</code></pre>
</div>
</div>


I have a report that contains a subreport.  When the subreport does not have any data to display I would like a label to appear with a message saying "No New Clients".  I have the label on the subreport with the visible property set to false.  I also have the below code.  This works when I run the subreport separately, but when I run it with the main report it does not work.  Any suggestions?

Display label when subreport empty

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.