Invalid or unqualified reference

[mitchmcc]

My question is more general than specific. Yes, I am getting the error mentioned in the Title. The full text of the message is:

The expression On Close you entered as the event property setting produced the following error: Invalid or unqualified reference.

This is from an Access project that I inherited. To make it worse, I think that I may have simply fat-fingered the VBA file somewhere, but this error does not tell me where, and this happens immediately when I try to go into Design mode.

Is there any other information I can get (or something I can do) to find out exactly where/why Access (2007) is unhappy?

Thanks,

Mitch

[mitchmcc]

FYI, I found my problem, but the general question still applies. The problem was that I inadvertently used "!" for "Not".

Any answers to my general question about debugging these types of errors would still be appreciated.

[orange]

Download a free utility called MZTools. http://www.mztools.com/v3/mztools3.aspx

Whenever you create a module, use MZTools to apply Error Handling (which it will do at the click of a button).
There are many other utilities included in the MZTools package.

! has special significance in Access.

[mitchmcc]

Thanks for the tip. I will check it out.