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
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