Calculations in Form do not display in the table

S

Steve Garrill

Help!
I've created a simple table.
From that I created a form to enter the data.
One of the fields (subtotal) adds two other fields together eg
[input1]+[input2]
The result displays correctly in the form but when I go back to the table
the input1 and input2 values are displayed but nothing where the subtotal
should be.
It worked the other day so I've changed something and I've now spent almost
3 hours trying to work it out!
 
R

Rick Brandt

Steve said:
Help!
I've created a simple table.
From that I created a form to enter the data.
One of the fields (subtotal) adds two other fields together eg
[input1]+[input2]
The result displays correctly in the form but when I go back to the
table the input1 and input2 values are displayed but nothing where
the subtotal should be.
It worked the other day so I've changed something and I've now spent
almost 3 hours trying to work it out!
Click to expand...

I doubt that it worked the other day. Controls bound to expressions never save
their values to the table. The ONLY way that a control's value is saved to the
table is when the ControlSource is the name of a field, not an expression. The
result of expressions do not need to be saved to tables nor should they be.
 
Top