There may be times when you have added some error-handling routines but these themselves have errors in them. What you do in these circumstances is go to the Tools menu, pick Options , and then select the Advanced pane. Among the Coding Options group is Break on All Errors :
If you turn on this option, Access will ignore your error-handling routines and always use the default. This allows you to code error routines as you create your application, but have the option to turn your error routines off for debugging purposes.