Need Link Child/Master Help!

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

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