Preventing the "Halt" message

[JCDTV]

I have a form, that when opened, uses a macro to run an update query. The query prompts for parameters, and when i hit the cancel button for those parameters, I get a message box "Action Failed" and I have to hit the "Halt" button to close it. This message box tells me that a macro is currently running, and hitting cancel halts it. Is there a way I can stop this box from appearing when I press the "Cancel" button?? Thanks in advance for any help!

 

[Pat Hartman]

You can't put error trapping in macros. Convert the macro to code and then put error trapping in the code to intercept the message and ignore it.