In Tools>Options>General tab, select "Break on All Errors". This will always
break execution to the debug window. Normally, you would probably want
"Break on unhandled errors". However, it seems that you also have a problem
with an error handler not handling an error gracefully, e.g. using End
rather than Exit or popping an alert dialog to inform the user (in this
case, you) as to why the program crashed. You should only enable "Break on
all errors" when you are diagnosing a problem like this. When you find the
problem, create an error handler that properly handles it and then set your
options back to "Break on unhandled errors". Users don't like to be thrown
into code-mode. They don't understand it. Just give them something in plain
English.
--
----
Ed
----