calculated value store in a table

[cmw]

I have a table field for GrandTotal. In a form GrandTotal textbox controlsource=Sum([Amount]).How will save it controlsoure=GrandTotal. Also same for many calculated field? Cursor dont put into that field.
Please help me.

 

[stopher]

The golden rule is you don't store calculations in tables. You just re-calculate them as and when you need them.
Chris