When working with Access's error handling, look at each command that can be used: On Error, Exit, and Resume.
The On Error command lets you specify exactly where you want Access to proceed to when an error occurs. Following are the variations of the On Error command used to direct program execution.
To control error handling, you must take over for the default handler by issuing the On Error Goto statement:
On Error Goto LineNumber|LineLabel
The On Error Goto statement has two options:
LineNumber can be a number placed in your routine.
Although VBA lets you use line numbers to specify lines to go to, it's not good practice to do so. Goto tends ...