Update a table on second subform

[Arturo]

I have a form with a subform within it. The subform is named frmNEWSUB. I use
this subform to load up eight other subforms within it using the script below:
Me.frmNEWSUB.SourceObject = "frmSUBFORM1"
or whatever the subform may be named.

Some of the subforms have different tables behind them. How do I update
Field2 in Table2, which is the recordsource for Subform2, after an update in
Field1 in Table1, which is the recordsource for Subform1?

Thank you.