Avoiding a run-time error

[jgarnick]

I have a form that is based on a query.&nbsp;&nbsp;In the query I have criteria for a field that asks for a value.&nbsp;&nbsp;If the user clicks cancel in the Parameter Value popup box that appears when the form is opened, a run-time error message appears that has Debug or End as possible choices.&nbsp;&nbsp;Since debug will put the user in the program, I want to avoid this error.&nbsp;&nbsp;I know I could create a form that would ask the same question, but I was wondering if there was an easier way.&nbsp;&nbsp;I haven't worked with error-trapping yet.<br><br>Thanks!! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[DougP]

Are you calling a msgbox yourself or...<br>You could try putting the criteria of the query a text box on your form instead of putting [Enter some value] in your query.<br>Then your query would run only when neede instead of everytime.<br><br>Lets see some code... <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[jgarnick]

Good idea--I'll try that....thanks! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>