Parameter Cancel Button - Action Failed HELP!!

[RustyR]

Good Morning!
I have tried everything I can think of but to no avail.
If I call a Macro which opens a query with 2 date parameters (start and end
dates) but decide to hit Cancel on either input box, I get "Action Failed"
dialog. The only option then is to hit "Halt" - Can this be avoided?
I have set Warnings to No then back to Yes in the macro.

Any help would be greatly appreciated!
Rusty

 

[Rick Brandt]

Good Morning!
I have tried everything I can think of but to no avail.
If I call a Macro which opens a query with 2 date parameters (start and end
dates) but decide to hit Cancel on either input box, I get "Action Failed"
dialog. The only option then is to hit "Halt" - Can this be avoided?
I have set Warnings to No then back to Yes in the macro.

Any help would be greatly appreciated!
Rusty

One of the primary reasons to avoid macros is that they have no way to handle
errors. If you did this with code instead you could trap for error number 2501
which is raised any time an interface action is cancelled.

 

[RustyR]

Thanks for the reply Rick.
I figured that I may have to code it, but being new, I thought there may be
a simple workaround I have missed.
I will code it.

Rusty