Assigning a calculated txtbx value to a field in the associated ta

[datamanipulator]

I have a sum value a the control source on one of my text boxes on my form; I
would like the value, as a number, placed into a field in the asssociated
table.
How do I do this?

 

[Jeff Boyce]

If I'm understanding your question correctly, you DON'T! Typically, it
isn't necessary to store a calculated value in a table. There are some
situations in which it does make sense, but you'll need to be a bit more
description if we're to be able to tell if your situation is one of those.

For example, what are you calculating?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[datamanipulator]

The data is a series of numbers that are identified with a field description
eg: Description I:bedrock is 0, boulder is 1....
Description II: Streambank Erosion: none=0, fluvial=1...
when summed will define a rank in a ranking scheme- this is the value that
needs to be stored in the table.

 

[Jeff Boyce]

If you can 'calculate' the value based on values existing in the
database/table, you (still) don't need to store the calculated value. Just
use a query to do the calculation and display that on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[datamanipulator]

Thank you Jeff,

If you can 'calculate' the value based on values existing in the
database/table, you (still) don't need to store the calculated value. Just
use a query to do the calculation and display that on a form.

Regards

Jeff Boyce
Microsoft Office/Access MVP