<div>
You need to set the Cancel parameter to TRUE:<br />

<pre><code id="code-20-40316060-1">Private Sub Report_NoData(Cancel As Integer)
    ' display your custom message box here
    Cancel = True
End Sub</code></pre>
</div>


You need to set the Cancel parameter to TRUE:


Private Sub Report_NoData(Cancel As Integer)
    ' display your custom message box here
    Cancel = True
End Sub

<div>
You will also need to handle the error message your main application will get when the report fails to open.<br />
<br />
I cannot remember what the error number is, but I just use a Resume Next after testing for that error.
</div>


You will also need to handle the error message your main application will get when the report fails to open.

I cannot remember what the error number is, but I just use a Resume Next after testing for that error.

<div>
Thanks for the error handling code. &nbsp;This worked perfectly.<br />
<br />
Sandra
</div>


Thanks for the error handling code.  This worked perfectly.

Sandra

<div>
<div class="content wysiwyg-content">
I have the message no data for report in the ON NO DATA event, but the report still opens. &nbsp;How can I prevent the report opening when there is no data?<br />
<br />
Sandra
</div>
</div>


I have the message no data for report in the ON NO DATA event, but the report still opens.  How can I prevent the report opening when there is no data?

Sandra

stop report opening if no data ACCESS 2010

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.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.