Data entered in Form not showing up in Worksheet

[Trina L]

Hi - I have just started using Access & have came up with a problem & am
hoping someone can help me.

I have created a form & a few of the text boxes have formulas or
calculations but when I enter in the information it is not showing up in the
worksheet, the field is blank.

For example, the field NET TONNE calculation is (Gross Tonne - Tare), the
calculation works out on the form but does not show up on the worksheet.

Does anybody know why this is happening?

 

[Rick Brandt]

Hi - I have just started using Access & have came up with a problem &
am hoping someone can help me.

I have created a form & a few of the text boxes have formulas or
calculations but when I enter in the information it is not showing up
in the worksheet, the field is blank.

For example, the field NET TONNE calculation is (Gross Tonne - Tare),
the calculation works out on the form but does not show up on the
worksheet.

Does anybody know why this is happening?

It's an expression. Where in the table would you expect it to show up?

The result of expressions should not be stored. Just calculate the result
whenever you need it (just as you are now).