Catching the "cancel" button request on the input box of a query

[kevink]

How can I detect if the user has hit &quot;cancel&quot; on the input box of a query?<br>
<br>
The query is designed to prompt the user for the criteria. I then requery the form if they want to do another search (me.requery). The problem then occurs if they press &quot;cancel&quot; - it causes an error in the code - so I'd really like to catch this and exit gracefully.<br>
<br>
In the same vein is there anyway I can find if the query results in a null value and display a message/input box with a message?<br>
<br>
Thanks,<br>
<br>
Kevin.

 

[elizabeth]

On the second question do you mean if there is no data in the report? There is an On No Data event, example:<br>
<br>
Private Sub Report_NoData(Cancel as integer)<br>
MsgBox &quot;There is no data that matches the parameters...&quot;<br>
Cancel = True<br>
End Sub

 

[elizabeth]

On the first question try the standard input box, it gives you OK & Cancel buttons by default:<br>
<br>
Dim strParm As String<br>
strParm = InputBox(&quot;This is the prompt&quot<br>
<br>
I<br>
<br>

 

[BarryG]

Use error handling. Trap the specific error with a specific message.

 

[BarryG]

Use error handling. Trap the specific error with a specific message.