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!

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.