insert calculated values in a table field

[brs]

hi,



i have a subform which contains a lot of calculated values. fields which calculate values are located both in master form and subform. i use those calculated values in various reports where i have to insert formulas again. so i have decided to insert calculated values in table directly. i can use update query but i am unsure how to trigger it; and how to keep fields updated everytime a value is changed.

main form fields = [gsm] , [rate]

sub form fields = [pages], [qty], [gsm]*[rate]*[pages]*[qty]

[June7]

Possibility of saved calculated value getting 'out of sync' with raw data is why it is not usually a good idea to save calculated values.

Figuring which event(s) to use is the real trick.

Perhaps the subform BeforeUpdate event.

Me.calcfieldname = Forms!Main.[gsm] * Forms!Main.[rate] * [pages] * [qty]