Cannot assign values in a subform

[CW]

I have an Agents table and form, and an AgentContacts table and subform that
sits within the Agents form. The tables are related by a one-to-many join
from Agents.AgtContact to AgentContacts.AgtContact.
The link between the forms is on the AgtName field.
No matter what I do, as soon as I try to enter any data in any of the fields
in the subform I get the error: You can't assign a value to this object (with
3 possible causes, none of which apply).
The crazy thing is that I have an identical structure in my Corporates and
CorporateContacts tables and forms, which work absolutely fine. I have
compared the designs till I am blue in the face and mad with frustration -
what on earth is causing this????
Thanks for your help (please!!!)
CW

 

[jahoobob via AccessMonster.com]

Try linking the forms with AgtContact.

I have an Agents table and form, and an AgentContacts table and subform that
sits within the Agents form. The tables are related by a one-to-many join
from Agents.AgtContact to AgentContacts.AgtContact.
The link between the forms is on the AgtName field.
No matter what I do, as soon as I try to enter any data in any of the fields
in the subform I get the error: You can't assign a value to this object (with
3 possible causes, none of which apply).
The crazy thing is that I have an identical structure in my Corporates and
CorporateContacts tables and forms, which work absolutely fine. I have
compared the designs till I am blue in the face and mad with frustration -
what on earth is causing this????
Thanks for your help (please!!!)
CW

 

[CW]

Thanks - in actual fact the link was correctly based on AgtName, but your
suggestion to change this made me look at it again, and there was a typo!!!!!
Duh!!!As soon as I corrected this everything is now fine, so thanks for
pointing me in the right direction!!

 

[jahoobob via AccessMonster.com]

Must be a defective keyboard! I hate those kind.

Thanks - in actual fact the link was correctly based on AgtName, but your
suggestion to change this made me look at it again, and there was a typo!!!!!
Duh!!!As soon as I corrected this everything is now fine, so thanks for
pointing me in the right direction!!

Try linking the forms with AgtContact.

[quoted text clipped - 11 lines]