<div>
I was afraid of that.<br />
<br />
Thanks
</div>


<div>
If I wanted to use a textbox and verified the input.<br />
Could I add the Filter and Where parameters to the DoCmd.openReport statement to accomplish the same thing?<br />
<br />
Something like:<br />
DoCmd.openReport &quot;ThisWeekPayReport&quot;, acViewReport,Filter=[Emplo<wbr />yeeNumber]<wbr /> ,WHERE=textbox.value , acDialog
</div>


If I wanted to use a textbox and verified the input.
Could I add the Filter and Where parameters to the DoCmd.openReport statement to accomplish the same thing?

Something like:
DoCmd.openReport "ThisWeekPayReport", acViewReport,Filter=[EmployeeNumber] ,WHERE=textbox.value , acDialog

<div>
<div class="content wysiwyg-content">
DoCmd.openReport &quot;ThisWeekPayReport&quot;, acViewReport, , , acDialog<br />
<br />
The above command is fired by a button on a form. The data source of the report has a criteria of employee number. Once the button is clicked Access opens a dialog box titled &quot;Enter Parameter Value&quot;. &nbsp;If an incorrect number is entered how can I catch it?<br />
<br />
Is there some kind of an OnError condition that I could place the DoCmd inside of that would catch it if an incorrect number was entered?<br />
<br />
<br />
<br />

</div>
</div>


DoCmd.openReport "ThisWeekPayReport", acViewReport, , , acDialog

The above command is fired by a button on a form. The data source of the report has a criteria of employee number. Once the button is clicked Access opens a dialog box titled "Enter Parameter Value".  If an incorrect number is entered how can I catch it?

Is there some kind of an OnError condition that I could place the DoCmd inside of that would catch it if an incorrect number was entered?





Catch error on open report

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.