G
gd
Hey, this is a question about an A2000 database,
I have a main form, frmParts. This is linked with tblParts and has
PKs Part_No and Eng_Rev. There is a subform on it, sbfDimensions.
The subform displays tblValidPartDimensions and has PK Dimension_No
with FKs Part_No and Eng_Rev. So these are linked by Part_No and
Eng_Rev.
The problem happens whenever I add a new record and start to type on
the main form. The subform fills in automatically with Dimension
records already saved instead of being blank and allowing child record
entry. However, when I save the record, go to another record, and
then come back to it, the subform has cleared. I honestly have no
idea what is causing this problem. Thanks for any help.
I have a main form, frmParts. This is linked with tblParts and has
PKs Part_No and Eng_Rev. There is a subform on it, sbfDimensions.
The subform displays tblValidPartDimensions and has PK Dimension_No
with FKs Part_No and Eng_Rev. So these are linked by Part_No and
Eng_Rev.
The problem happens whenever I add a new record and start to type on
the main form. The subform fills in automatically with Dimension
records already saved instead of being blank and allowing child record
entry. However, when I save the record, go to another record, and
then come back to it, the subform has cleared. I honestly have no
idea what is causing this problem. Thanks for any help.