<div>
You need to add error handling to the routine that opens the report<br />
<br />
Gary
</div>


You need to add error handling to the routine that opens the report

Gary

<div>
<div class="content wysiwyg-content">
I have a report which is opened from a menu. This report opens a dialog form from the report 'On Open' event to get a date range. On this form I have a 'Cancel' button in case the user changes their mind and this closes the form and sets a flag. This flag is checked by VBA in the report 'on open' event and exits from the report &nbsp;with the statement 'Cancel=true'. However, this produces the error &nbsp;2501 &quot;The OpenReport Action was cancelled&quot;. I do not get this error if I open the report directly (ie not from my Menu form)<br />

<pre><code id="code-313819">cancelrep = False
DoCmd.OpenForm &quot;ChooseRepMonthYear&quot;, , , , , acDialog
 If cancelrep Then
   Cancel = True
   Exit Sub
End If
</code></pre>
</div>
</div>


I have a report which is opened from a menu. This report opens a dialog form from the report 'On Open' event to get a date range. On this form I have a 'Cancel' button in case the user changes their mind and this closes the form and sets a flag. This flag is checked by VBA in the report 'on open' event and exits from the report  with the statement 'Cancel=true'. However, this produces the error  2501 "The OpenReport Action was cancelled". I do not get this error if I open the report directly (ie not from my Menu form)

Access 2007 - Cancelling openreport from VBA code

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.