T
Thomas
Hi, all
This thing really bewildered me.
I have a main form and a subform on the main form. Both
are based on a query. The main form and the subform is
linked by something like testplanID. TestplanId on the
mainform corresponds to an autonumber field in the
underlying query. In relations, I have turned on
integrity, cascaded update and cascaded delete between the
one table and the many table.
The problem is I have several such main-subforms in my
database based on similar queries. On the other two
main/subform, whenever I finish inputs in mainform and
then click into the subform, the linked field in the
subform already has value populated from the linked field
in the main form, but in my problematic main/subform, it
does not. I have to write code in an event and update the
linked field.
Anyway pls enlight me on this thing....
Thanks a lot!
Thomas
This thing really bewildered me.
I have a main form and a subform on the main form. Both
are based on a query. The main form and the subform is
linked by something like testplanID. TestplanId on the
mainform corresponds to an autonumber field in the
underlying query. In relations, I have turned on
integrity, cascaded update and cascaded delete between the
one table and the many table.
The problem is I have several such main-subforms in my
database based on similar queries. On the other two
main/subform, whenever I finish inputs in mainform and
then click into the subform, the linked field in the
subform already has value populated from the linked field
in the main form, but in my problematic main/subform, it
does not. I have to write code in an event and update the
linked field.
Anyway pls enlight me on this thing....
Thanks a lot!
Thomas