J
JohnLute
I have a database with many forms and subforms. For example,
sfrmPKCorrugatedHorizontalScores is a subform in
sfrmPKCorrugatedPhysicalAttributes which is a subform in frmPKCorrugated. All
linked by [txtProfileID].
The challenge is that in order to enter a record in
sfrmPKCorrugatedHorizontalScores a record must first exist in the tables
underlying sfrmPKCorrugatedPhysicalAttributes and also frmCorrugatad -
obviously. Since I know this "quirk" in the design it's easy for me to enter
a value in one of the subforms in order to create a record and then go back
and delete that value however this is clumsy and not at all what I'd want to
teach other users.
What event procedure do I need to write in sfrmPKCorrugatedHorizontalScores
that will create a record in the table underlying sfrmPKPhysicalAttributes?
I'm sure this can be done and I previously explored it here but with no
resolution.
Thanks for your time and interest!
sfrmPKCorrugatedHorizontalScores is a subform in
sfrmPKCorrugatedPhysicalAttributes which is a subform in frmPKCorrugated. All
linked by [txtProfileID].
The challenge is that in order to enter a record in
sfrmPKCorrugatedHorizontalScores a record must first exist in the tables
underlying sfrmPKCorrugatedPhysicalAttributes and also frmCorrugatad -
obviously. Since I know this "quirk" in the design it's easy for me to enter
a value in one of the subforms in order to create a record and then go back
and delete that value however this is clumsy and not at all what I'd want to
teach other users.
What event procedure do I need to write in sfrmPKCorrugatedHorizontalScores
that will create a record in the table underlying sfrmPKPhysicalAttributes?
I'm sure this can be done and I previously explored it here but with no
resolution.
Thanks for your time and interest!