problem completing child field in subform

[Guest]

Hi Access Gods:

I have a form( [frmMain] ) with two subforms ( [frmSub1] & [frmSsub2]).
[frmMain].[name] is the primary key. [frmSub1].[name] & [frmSub2].[name] are
the child fields, which link up with [frmMain].[name].

There are 1-to-many relationships established with the tblMain and tblSub1,
tblSub2.

Normally, when i create these forms-subforms, i could go to a particular
record on [frmMain], and enter in information on [frmSub1] and
[tblSub1].[name] would automatically be completed in the underlying table.
However, in this case, Access is not automatically filling in the [name]
field on either of the sub-tables. I am also getting this error, "This
property is read-only and cannot be set."

Please help...

 

[Allen Browne]

Forms in Access have a Name property. Access is getting confused between the
Name of the form, and your field called Name.

Rename the field to something else. Rename the text boxes, and the entries
in the LinkMasterFields/LinkChildFields.

If it still does not work after that, make sure Name AutoCorrect is off.
Explanation:
http://members.iinet.net.au/~allenbrowne/bug-03.html