Delete Macro no warning

[bsells]

I have a delete macro that deletes the record in the navigation pane. Unfortunately it does it with no warning. I even went in and and setwarning = true and it still doesn't. I need the warning, please help.
B

 

[Ranman256]

if the macro is running a query, the the setwarning will work.
if its NOT a query, what is it running?

 

[bsells]

it is doing a RunCommand DeleteRecord

 

[Ranman256]

use
setwarnings true
openquery "qdDelrec"

(build a query)

 

[bsells]

this is what it looks like now

 

[bsells]

I hate to turn to a query when the macro performs perfectly and all i need is a warning. Any help is greatly appreciated.

 

[Eljefegeneo]

This may not be an optimal solution, but I always use a message box asking if the user really wants to delete the record. VbYesNo, if no, exit.

 

[Eljefegeneo]

Not sure how it is done on MS2003, but on 2010 this works in the macro builder:


IF MsgBox("Are you Sure?",4)=7 then
StopMacro
Else
Your delete code