Exit Query

Microsoft Access

How can I embedd a function into a query that will cause the query to shut itself down upon error? I've tried several attempts but nothing seems to work.. I usually get the error that I can't close the query because it's calculating or repainting but I know that in long queries I can abort with control-break. When I use sendkeys for that combination in a function it just skips the record and goes on. Any Ideas?

use DoCmd.RunSQL and have error trapping on it..... if it errors, exit .. or do whatever...