Automation Error

[T13v0hz]

I get the error on one of my forms which has two subforms embedded, which all run the same primary key.

I keep getting the error:

The LinkMasterFields property setting has produced this error: 'The object doesn't contain the Automation object 'Jobs."

Jobs is my main table and I can't get a proper answer out of Microsoft help with this error.

This pops up numerous amount of times until I have entered in the same PK in all three forms.

 

[Calvin]

Look into how you have your Relationships configued, you may have "Enforce Referential Integrity" enabled and if your subtables don't have related records, you get an error.

 

[T13v0hz]

Problem solved, Thanks all the same.

 

[NZArchie]

Sorry to bring this back from the dead, but how did you solve this problem? I have a similar problem with creating a new record via subform. It appears I need to pass a primary ID from the main form, to the new record.