I have built a form and in a field i put a formula for calculating GSM, GSM is calculated but not save in Table. What i do?

---

Reply from Richard Rost:

Values that are calculated on a form in a form field are not stored in the underlying table. Most of the time, you don't need them to be. When you're calculating, for example, PROFIT = SALES - EXPENSES, you don't need to store that value because you can always use a form or calculated query field to recalculate it on the fly.

However, if you want to store that value in the field for any reason, you can... but you'll have to make a field for it in your underlying table, bind that form field to it (set the ControlSource), and then you'll either need some VBA with an AfterUpdate event to SET that value OR you can use Access 2007's new Calculated Field data type. I'll be covering the latter in an upcoming class.