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.

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" <mtharrisky (AT) insightbb (DOT) com> wrote