Form.OnError event

D

Daniel

Hi,
Does anyone knows if an error happens in a VB procedure in the form's module
is trigerring this event ?

I want to handle errors but don't want to add each procedure its own error
handler - it's making the code much longer and it's very difficult to manage
the error handler if you want to change it.

Thanks,

Daniel
 
A

Allen Browne

Each procedure must have its own error handler. Form_Error does not catch
VBA errors; it catches engine-level errors, such as if the user tries to
save the record in the form without supplying a value for a Required field.

The error handlers do make the code longer, but there are utilities that let
you drop in the error handler exactly as you want it, with just a mouse
click. My favourite is a free one from Carlos at www.mztools.com (It actully
does lots of other useful things as well.)
 
Top