Unusual Error: Help!

[James Keenan]

MS Access continues to report this error:

"This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a number expression
may contain too many complicated elements. Try simplifying
the expression..."

Then if you click OK, an additional box appears
stating "Object Invalid or no longer set." After this
warning appears, it's impossible to enter anything and
Access must be shut down.

The error comes about only when adding a new entry to the
database. Please, any help is greatly appreciated. Thank
you.

 

[Tony Toews]

"This expression is typed incorrectly, or it is too
complex to be evaluated. For example, a number expression
may contain too many complicated elements. Try simplifying
the expression..."

Then if you click OK, an additional box appears
stating "Object Invalid or no longer set." After this
warning appears, it's impossible to enter anything and
Access must be shut down.

The error comes about only when adding a new entry to the
database.

How are you adding the new entry? Via a form? Does this happen when
you key the first character in a new entry on the form or when you go
to save the record?

If a form post the code behind the BeforeInsert or AfterInsert event.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm