Brett,

You might try setting the button Cancel proprty .T. If that doesn't work you'll need to add a DoEvents() call into the query. But be warned each call takes on the order of 0.25 seconds to execute. On my website is a wrapper object that lets you control how many iterations of a loop to occur for each actual call to DoEvents().

>I wa wondering if there was a way to start an SQL query and have a CANCEL button on the screen, in which the user presses when they wish to stop the query. Then the user should see a screen that says 'You pressed cancel are you sure you wish to stop the query?' if the user presses yes then the query stps, else a no would start the query back up.
>
>Can this be done with VFP or am I wishing for more than I can do?