subform error message about automation object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JeanneG - 04 Nov 2007 07:34 GMT

I have a subform that lets me edit existing records with no problem. When I
attempt to type the first character in a new record (any field) I get the
message "the object doesn't contain the automation object 'Project.'"
Project is a table used in the subform.

When I close the message I can proceed with the data entry and the record is
saved just fine.

There are no macros or VB code involved in this form or subform.

I want this to keep working just as it is -- but without the error message!
Any suggestions?

Reply to this Message

Arvin Meyer [MVP] - 04 Nov 2007 17:13 GMT

This usually occurs if there is an equal sign proceeding a named object.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have a subform that lets me edit existing records with no problem. When I
> attempt to type the first character in a new record (any field) I get the
[quoted text clipped - 10 lines]
> message!
> Any suggestions?

Reply to this Message

JeanneG - 05 Nov 2007 03:46 GMT

Arvin, what a useful tip! I do have equal signs in default values.

I'm not certain yet whether this is the full solution, because I've gone on
to other interesting challenges with this form, sigh, but I appreciate the
tip and will also keep it in mind for future forms.

> This usually occurs if there is an equal sign proceeding a named object.
> >I have a subform that lets me edit existing records with no problem. When I
[quoted text clipped - 11 lines]
> > message!
> > Any suggestions?

Reply to this Message