I appreciate the offer! Unfortunately I think First Union would frown on me sending customer info out as a test file (even if I did blank name info,etc.)

I do try to make my SELECTs as fast as possible but we pull reports off tables with 1/2 a million+ records in each, so this is something that is important to us.

I actually have come up with a solution for my application.

In the click event

lnnowwhat=messagebox("Are You Sure You Want To Cancel?"+chr(13) ;
+" Report Creation Will Terminate",36,"Abort Update?")
if lnnowwhat = 6
go_on = .f.
else
retry
endif

then I wrap the rest of the report generation code after the SELECT with an IF statement

IF go_on
repo form blah
ENDIF

Granted this is not the most OO way to do it but hey it WORKS GREAT!!!

Thanks for your input!!