Macros

[kstyles]

I have a macro set to close a particular loan. It opens a query then based on a select parameter query where the end user inputs a specific loan number, it will update the status to closed. However, if you click cancel then the macro brings up the "action failed" message. My question is what clears this message - so that the user can change their mind and they won't have to see this.



I've tried clear macro error, on error - set arguments to fail....

Not really clear on how to make this box stop coming up.

[kstyles]

The "enter parameter value" box pops up and you have the option to enter a number or if you click cancel it will not update... however when you click cancel an "action failed" box pops up...

It says error number 2950... and then has a button that says "stop all macros." This is okay for me - no big deal, but I don't want the end user to see this. Is there a way that I can have this not pop up when the canceled button is clicked?

[kstyles]

I figured this one out on my own...

Set the actions in the buttons on click property to run a macro

Actions run in this order
OnError - argument - next
msg box
open query
clear macro error

Now only my own message boxes pop up...

Thought maybe someone else could use this info.