Error 2766 - object doesn't contain the automation object '|."

[trab]

I'm starting to get the above error occasionally when I try to open a form using VBA. I say occasionally deliberately, because sometimes it works and sometimes it doesn't. I've tried compacting the database base more than once, but that doesn't throw up any problems. I'm also starting to get the error "problem executing a command" when opening a form from the switchboard.

What does '|." mean here?

 

[DHookom]

Is there any code/VBA in the form? Are there any unique types of controls? Is the recordsource a table or plain vanilla query?

 

[The_Doc_Man]

Regarding the "|." problem...

You probably have a mis-identified field in an underlying query on that form. It COULD be the me.RecordSource query, particularly if your record source is an SQL statement rather than a named/stored query. It could ALSO be a .RowSource query if you have any combo or list boxes on the form. And if there is any dynamically generated query under anything - including a sub-form - then the sub-form's query might be the culprit. It is possible that if there is a LEFT or RIGHT JOIN involved that one of the fields in question is unmatched in the JOIN and thus NULL. In all cases, that is a field problem in a query intimately related to the form that is throwing the error.

The "problem executing a command" is going to require more info.