Does Not Contain Automation Object...

Samantha

still learning...
Local time
Today, 14:36
Joined
Jul 12, 2012
Messages
187
Error: "The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'tblProposals."

I have a form "frmProposalDetails" that has many sub-forms on it, the main source table is named tblProposals. Although, I have a query based on that table and combining two additional tables set as the forms source. The original table "tblProposals" I have gone back and added two additional fields. So the point at which my form begins throwing up the error is when I modify the query that the form is based on in an attempt to add the two additional fields. The error pop's up 2x after clicking ok the form displays the records properly. Also, I have read the posts regarding the * being used to add a whole table to a query; it is not built in that way each field was added independently.
Some other perhaps non-essential information - there is an update macro on the inital table that is an audit trail; I added the two additional fields to it with success. There is an on-load macro that goes to the last record.
I have searched through the forum, and google, and checked everything I can think of. I am using Access 2010. Any help would be greatly appreciated!

Samantha
 
Just to update - I solved my own issue after spending half the day on it. Even though what I was attempting to add was "in my eyes not related" to the sub-form. The problem for me was in the filter on load property. Resetting the filter criteria solved it.
 

Users who are viewing this thread

Back
Top Bottom