How can I detect if the user has hit "cancel" 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 "cancel" - 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.
<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 "cancel" - 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.