I have a main form that contains two sub forms. The Link Master Field for both Sub Forms is [Lot_Number].
Sub form #1 is based on q-LotNumberContainerWeights, uses Datasheet View, and is the data entry form. In this case, a user is entering the [Weight] of various containers that are unique to a particular [Lot_Number].
Sub Form#2 is based on t-LotNumberContainerWeightTotal and displays the [Total_Weight] of all containers from [Lot_Number].
I would like the [Total_Weight] shown in Sub Form#2 to be updated after the user enters/modifies data into Sub Form#1.
How do I accomplish this?