Totals Update

[GJT]

I have a Stock record form where material items are recorded along with their costs.

The subform lists all contracts that are allocated units of this material. The subform has a Value column that is an unbound field ie. calculated from : QtyIssued * [ParentForm]!UnitCost.

I now need to store this calculated value in the subform table but need to ensure that if the unit cost item on the parent form is updated - this automatically updates all dependant values in the subform. What is the best way to go about this please?




Thanks for your help.