problem completing child field in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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
 
Back
Top