R
Rich J
I have a main form with several subforms. I need to find a way when creating
a new record that all the records of two continuous subforms can be
duplicated and associated with the new mainform.
In creating the mainform record a new DiaryID is created and this field is
inserted in every record of the subform. Each subform record is unique but
all the ones associated with the main form are linked with the DiaryID as one
of the Primary keys.
All subform records that need to be duplicated could be selected where the
DiaryID field has the same value. Then I would have to paste them to the
subform tables with the new DiaryID from the new mainform diary in those
records.
Thanks for any ideas. I looked at various copying codes but none go to the
subform.
a new record that all the records of two continuous subforms can be
duplicated and associated with the new mainform.
In creating the mainform record a new DiaryID is created and this field is
inserted in every record of the subform. Each subform record is unique but
all the ones associated with the main form are linked with the DiaryID as one
of the Primary keys.
All subform records that need to be duplicated could be selected where the
DiaryID field has the same value. Then I would have to paste them to the
subform tables with the new DiaryID from the new mainform diary in those
records.
Thanks for any ideas. I looked at various copying codes but none go to the
subform.