• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 963
  • Last Modified:

'The object doesn't contain the automation object 'opportunity_id''

The object doesn't contain the automation object 'opportunity_id''

I have a form that has a subform, which is throwing the above error.  The subform has 2 tables it hits tbl_ClientOppJunction and tbl_Client, while the parent form hits the tbl_opportunity.  I have set the "Master Link Field" to "tbl_Opportunity.Opportunity_Id" and the "Link Child Fields" to "Opportunity_Id".  I can enter example data directly into the tables and it displays correctly, yet I can not enter it into the forms, I get the above error.  I have searched the web on this and found some references to making the automated object available, but I am not sure how to do this since I am not using macros nor VBA code, just properties.

3 tables involved.
tbl_Opportunity
tbl_ClientOppJunction
tbl_Client

0
Duane Lawrence
Asked:
Duane Lawrence
  • 2
  • 2
2 Solutions
 
rockiroadsCommented:
does the form field on either form that has opportunity_id

the name of the object is that, but what is the controlsource for that field? is it pointing to the right field?

0
 
Rick_RickardsCommented:
I would look at the query in the Master Table.  It would seem that it is including the field Opportunity_Id from multiple tables.  This could be due to explicit declarations or by including all fields from a table using the * character.  Once you remove the duplication you should be able to link to the Master field by declaring Opportunity_Id by itself and likely resolve the problem you're having in the process.

Rick
0
 
Duane LawrenceAuthor Commented:
Rick, Thanks, I am looking into your suggestion.

Rockiroads, I need more detail, I can't quite follow what your saying.
0
 
Rick_RickardsCommented:
Keep me posted.  Like to know if that does the trick for you.

Rick
0
 
rockiroadsCommented:
ok

lets try some things

1. do a debug/compile - any errors will show up, if nothing happens then all is fine

2. try a compact/repair

3. in code, is there anywhere u reference Opportunity_ID? does that field exist on the form where its being accessed?

4 In form design, if u look at a bounded field properties, it has a control source. One of these must be Opportunity ID

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now