Need Link Child/Master Help!

[Guest]

In Access 2002 I have a two deep nested subform with three Link Child/Master
fields. For some reason, the middle field generates a #Error in the sub form
control when I navigate to a new record. However, in datasheet mode, I can
open the superior table, click the “+†sign and create new records. The
queries that support the nested subfom and superior subfom have the field in
them. I can’t find anything wrong. Any ideas? Thanks.

 

[Allen Browne]

Many possibilities here.

Anything in the Default Value of the field that shows the error?

Any chance of a name clash here? For example, if one of the field is called
Name, Section or anything else that is a property of the form or could be
misunderstood, it will cause this error.

If one of the fields in the LinkMasterFields is a calculated field, could
the calcuation be inappropriate (e.g. division by zero)? Alternativley,
could the data type of the field be misunderstood? See:
Calculated fields misinterpreted
at:
http://members.iinet.net.au/~allenbrowne/ser-45.html

There may also be timing issues related to this. In one case that we saw in
A2000, applying SP8 for JET 4 and the SP for Office helped.

 

[Guest]

What if there is a control with the same name on another subform?

 

[Allen Browne]

No, that won't be a problem.