Writing calculated value to a table

[Guest]

I know this is simple but... I have an expense tracking form bound to a
table. To the delight of the user I've created a textbox control that adds
the expenses on the fly. How do I save that calculated value into the table
bound to the form?


Thanks,

Todd

 

[fredg]

I know this is simple but... I have an expense tracking form bound to a
table. To the delight of the user I've created a textbox control that adds
the expenses on the fly. How do I save that calculated value into the table
bound to the form?

Thanks,

Todd

You don't.
Think database, not spreadsheet.
All you need do is save the values that go into the calculation.
Then whenever you need to result of the calculation, calculate it, in
a query:
TotalAmt:[FieldA] + [FieldB]

on a form, or in a report, using an unbound text control:
= [FieldA] + [FieldB