Master-Child Links Fail

  • Thread starter Thread starter Ian Smith
  • Start date Start date
I

Ian Smith

I have a very large and complicated form with about 20
tabs on it. And a couple of the tabs have nested tabs
within them.

To get acceptable performance, I had to stop the form from
populating all of the tabs each time the main from goes to
a new record. I did this by putting a subform on each tab,
and setting the SourceObject to an empty subform. When a
particular tab is clicked, I fess-up to the real subform
name.

My problem? Every once in a while (days or weeks), a
subform loses it's master-child link. I see the correct
values in design view, but even if I remove them and
respecify the links in design view, the form remains
broken. If I re-specify the master-child links in code, it
behaves properly.

What's happening here?
 
Ian, this can happen when assigning the SourceObject of a subform control at
runtime, esp. if the entries have different names, multiple fields, or the
data types need coercing.

It doesn't seem to happen when there is a relationship with Referential
Integrity and the primary key and foreign key fields have the same name and
consist of just one field.
 
Back
Top