F. Scott Barker's Microsoft® Access 2000 Power Programming

WORKING WITH THE ERR AND ERROR OBJECTS

There are different ways to use the Err object (used by Access) and Error objects (used by Jet), as well as the Error statement, which can make them confusing. It's best to examine them in the order that you'll use them.

In Access 97, the Err object contains information about the most recent error that has occurred. The Err object takes the place of the Err statement and Error$ in versions before Access 95. The Err object contains properties and methods, as do other Access objects. Table 7.1 shows the properties belonging to the Err object.

Table 7.1. Properties Used with the Err Object

Property	Description
Description	Contains the description of the error if a description exists.
HelpContext	Stores the context ...