Unbound Text Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sturner333 - 22 Jun 2006 13:40 GMT

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!

Reply to this Message

Rick Brandt - 22 Jun 2006 13:50 GMT

> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Al Camp - 22 Jun 2006 13:51 GMT

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.

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>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!

Reply to this Message