Access2003 Runtime Error

D

Dee

What can I replace END with in VBA - when using END in runtime - I receive an
error message - however Exit Sub and Exit function are of no value at times -
if the function is called from another procedure then the program will exit
from the first but continues on from the procedure which it was called from.
I need to stop the program at a particular point (mainly to display a
message) without it continuing on. The error only occurs when using /runtime
option
 
D

Dave Patrick

Generally speaking you need to trap that condition. Then you can act
accordingly with your MsgBox and or Exit Sub if that is what's required.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| What can I replace END with in VBA - when using END in runtime - I receive
an
| error message - however Exit Sub and Exit function are of no value at
times -
| if the function is called from another procedure then the program will
exit
| from the first but continues on from the procedure which it was called
from.
| I need to stop the program at a particular point (mainly to display a
| message) without it continuing on. The error only occurs when using
/runtime
| option
 
Top