Subform and Main form interaction

[Guest]

I have a main form that includes information on each field we own interest
in. I have a subform that is linked to the main form through "Field" (this
field is the same in the main form and subform) that list every company
(including ourselves) that owns interest in the field and what percentage of
interest each company owns. I often copy a record and change the field name
in the subform and mainform to save time typing similar information, but when
I change the field name in the subform, I am simultaneously deleting the
original subform contents so that when I return to the record I copied, the
subform contents are empty. How do I copy a record in which the main and sub
form contents are duplicated so I can change the duplicate without harming
the original?

In addition I have a "Last Updated" field on the main form that time stamps
the record in the Before Update event procedure to Now(). Unfortunately, when
I make changes to the subform, the 'update' is not acknowledged in the main
form. How can I create a Last Update timestamp for the entire record that
includes the main form and the subform?

Thanks so much!

 

[Guest]

Should I post this in a different forum? Any guidance would be greatly
appreciated!

 

[SusanV]

Hi Emmy,

Use the On Update event of the subform to trigger the timestamp rather than
before update.