S
Sheryl
My application has a Form (popup Yes, modal Yes) with buttons "Run" and
"Cancel". When "Run" is selected, the Click procedure calls a function in
another module (not linked to a form) which executes several macros one after
the other via e.g. DoCmd.RunMacro "myMacro_01". I would like to have a way
for the operator to break execution, e.g. between macros. I would like
clicking on the "Cancel" button to trigger this.
But the Hourglass is enabled, and the form doesn't recognize mouse hits!
Nor does Ctrl-break do anything, even when I call DoEvents between macro
calls.
Is there a way?? (I've been successful in making this happen when the Form
is in another application that executes procedures in my application. The
"Cancel" button doesn't visually respond to the click, but DoEvents does
work!)
"Cancel". When "Run" is selected, the Click procedure calls a function in
another module (not linked to a form) which executes several macros one after
the other via e.g. DoCmd.RunMacro "myMacro_01". I would like to have a way
for the operator to break execution, e.g. between macros. I would like
clicking on the "Cancel" button to trigger this.
But the Hourglass is enabled, and the form doesn't recognize mouse hits!
Nor does Ctrl-break do anything, even when I call DoEvents between macro
calls.
Is there a way?? (I've been successful in making this happen when the Form
is in another application that executes procedures in my application. The
"Cancel" button doesn't visually respond to the click, but DoEvents does
work!)