Value from field in my form not saving to the field in my table

[Guest]

I built a form and added a calculated field that sums up total. It
calculates just fine but, when I go to the table, the field remains blank and
will not populate with the calculated value. Would love some help- am sure
this is a quick fix find it.
B.

 

[fredg]

I built a form and added a calculated field that sums up total. It
calculates just fine but, when I go to the table, the field remains blank and
will not populate with the calculated value. Would love some help- am sure
this is a quick fix find it.
B.

There is no need to save that calculated value.
As long as your table contains the data needed in the calculation, any
time you need the result, calculated it.
In a query, for example:
Total[FieldA] + [FieldB])*[TaxRate]

or directly on a form or in a report, using an unbound text control:
=([FieldA] + [FieldB])* (1+ [TaxRate])

 

[Guest]

Fred. Thanks for responding. I agree- and would have expected the table to
populate with data entered from the Form. Set it up just as you indicated.
Still, data will not show up on the Table.
B.
--
Brigitte

I built a form and added a calculated field that sums up total. It
calculates just fine but, when I go to the table, the field remains blank and
will not populate with the calculated value. Would love some help- am sure
this is a quick fix find it.
B.

There is no need to save that calculated value.
As long as your table contains the data needed in the calculation, any
time you need the result, calculated it.
In a query, for example:
Total[FieldA] + [FieldB])*[TaxRate]

or directly on a form or in a report, using an unbound text control:
=([FieldA] + [FieldB])* (1+ [TaxRate])

 

[Rick Brandt]

Fred. Thanks for responding. I agree- and would have expected the
table to populate with data entered from the Form. Set it up just as
you indicated. Still, data will not show up on the Table.

Controls either save their value to the table (bound) or they contain
expressions. They cannot do both at the same time.

As Fred indicated, there is no reason to store that value and many reasons
NOT to. Just delete the field from your table and use the expression.