Re: Calculated Fields Info Being Put back into table

Generally speaking, calculated values shouldn't be stored in your database,
since Access can easily recalculate those values each time it needs to (and
since calculated values can change, depending on the values feeding the
value).

However, just set the controlsource of the textbox to = the field you want
to save it to.

"MTHarris" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have a database file that I have been working on which contains a form.
> On that form I have several.. = twenty'ish unbound text box's which I put
> formula's in that do various calculations.  The thing is...  what is the
> most simply and effecient way to have the end calculated value put back
into
> the table that the forms is assigned to?  I see it being some function
> assigned to a button.  I have been told that it can be done with macro or
> code.  However, does anyone have a sample database file that they might be
> willing to share so I can go in and actually see how it is done?  Any
> assistance would be greatly appreciated.
>
> Thanks
>
> MTHarris
>
> p.s.  there are many fields that are based on the table on that form, the
> twenty or so calculation text box's are in addition to those and are
> calculating numbers input into those other fields.
>
>