tranfering data from forms to tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

im new to Access 2003 so this question might sound simple to some users

In a form i have a text box and the control source is a calculation done
with expression builder. the problem is im having trouble transferring the
calculated value into a feild on a table. Any ideas how???

Can a table do calculations instead of a form??
 
StuJol said:
im new to Access 2003 so this question might sound simple to some
users

In a form i have a text box and the control source is a calculation
done with expression builder. the problem is im having trouble
transferring the calculated value into a feild on a table. Any ideas
how???

Can a table do calculations instead of a form??
Click to expand...

Most of the time you would not store a calculated value in a table,
because it's more efficient and more reliable to recalculate it whenever
you need it; for example, as a calculated field in a query. The main
exception to this is when the information to calculate the value
correctly isn't going to be available later -- but from the sound of
your closing question, what you really want to do is define a calculate
field in a query of the table, and use that query in place of the table
wherever you need the calculated value.
 
Back
Top