Cancelling a query running from a form.

S

SH

I am running a query from a button on a form. This button
calls the query and reports the output to a form.

My problem is... if you run the query and get to the pop
up parameter box, but decide you no longer want to run the
query. You would expect to be able to hit 'Cancel' as
works for a simple query, however this produces a run time
error and sends you to debug the code in the Visual Basic
window.

Any suggestions as to how to either write code to solve
this - or solve it some other way would be welcome.

SH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
VB code for running 1 query mulitple times with different input? 7
Print a report from a form based on a query 4
force focus on a query from a form 1
Run-time Error 2186 23
Routine to run/export queries 2
Running a query from a selection 16
How to minimize a form - Access 2007 2

Top