Strange subform error

  • Thread starter Thread starter gd
  • Start date Start date
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've tried everything I can think of so far and checked around on the
internet for a few hours. Anyone have this problem or know of what
might cause it?
 
I've tried everything I can think of so far and checked around on the
internet for a few hours. Anyone have this problem or know of what
might cause it?
Click to expand...

New strange update: I found that if I go to the record at the end of
the recordset (999 out of 999), and then go to make a new record
(1000), then the "auto-fill" of the subform does not occur. Perhaps
the problem has to do with caching all the records or something.
 
Do you, by chance, have a requery command programmed into your subform?
Requerying the form will cause it to return to the original record. I had
the idea from what you said about moving from record 999 to 1000, which is a
new record.
 
Back
Top