Hey guys,

I am looking to find out if there is a vbyes/no response to the SetOptions "Confirm Action Query" ?

I have a form that users can run their own sql queries from and it sends the results to excel. I often run delete statements from this form and would like my message label on the form to show that I've confirmed or cancelled the
delete query.

I just don't if or how you can incorporate a vbyes/no into this. Any ideas?
I really don't want to go to another type of delete confirmation, since it confirms how many records I am going to delete.

For example

If vbyes then message_lbl.caption = "Delete Complete."

I did search the forum, but didn't find anything close to what I'm trying to do.
Thanks guys!