Some interesting information courtesy of FMS
Comparison of Error Descriptions among Microsoft Access 2007 through 2000
http://www.fmsinc.com/MicrosoftAccess/Erro…ss2007-2000.pdf%5B/url%5D
Error Handling and Debugging Tips and Techniques for Microsoft Access, VBA, and Visual Basic
http://www.fmsinc.com/tpapers/vbacode/Debug.asp%5B/url%5D
An Explanation of Trappable Errors in Visual Basic for Apps
http://support.microsoft.com/kb/142138/en-us%5B/url%5D
HTH, John