Unbound Text Box

[Guest]

I am new to Access so this might seem simpleton to most. I have an unbound
text box that I put a calculated value in that will change as the user makes
other changes on the form. But I would also lile to save this data to the
same table that the rest of the form is bound to. What is the best way to do
this?
Thanks for the help!

 

[Rick Brandt]

I am new to Access so this might seem simpleton to most. I have an
unbound text box that I put a calculated value in that will change as
the user makes other changes on the form. But I would also lile to
save this data to the same table that the rest of the form is bound
to. What is the best way to do this?
Thanks for the help!

The best way is NOT to do it. Move that calculation to a query based on
your table and then use the query any place you need that value instead of
using the table.

 

[Al Camp]

sturner333,
Don't save the results of a calculated field. Since you've captured all the data the
calculation needs, you can always re-derive the calculation value "on the fly" in any
future form, query, or report.
ex. If I save Price and Qty
and
LineTotal = Price * Qty
I don't need to "save" LineTotal. I can just recalc it from Price and Qty any
time I need it.