Have Field Sum Other Fields On FOrm

[Richard_Marx]

I am attempting to have my field txtSum equal txtValueOne + txtValueTwo. I set the default value of txtSum =NZ([txtValueOne],0)+NZ([txtValueTwo],0) but txtSum is not auto-calculating. The control Source for my field is set to SUM as that is the database field I need this value to be stored in.

What do I need to change on my form so that txtSum auto-updates based off the value(s) entered in txtvalue one and txtvaluetwo?

[Bob Fitz]

Use your expression:
=NZ([txtValueOne],0)+NZ([txtValueTwo],0)
as the control source setting txtSum

[Richard_Marx]

Use your expression:
=NZ([txtValueOne],0)+NZ([txtValueTwo],0)
as the control source setting txtSum

Ah - ingenious! Will this still update my database table tblData with the value that txtSum calculates?

[Bob Fitz]

Ah - ingenious! Will this still update my database table tblData with the value that txtSum calculates?

No it will not save the calculation. Generally it is not considered to be good practice to save calculations. Better to recalculate whenever and wherever required.

[Richard_Marx]

No it will not save the calculation. Generally it is not considered to be good practice to save calculations. Better to recalculate whenever and wherever required.

How would I re-calculate so the value get's saved in my table?

[Bob Fitz]

Ah - ingenious! Will this still update my database table tblData with the value that txtSum calculates?

No it will not save the calculation. Generally it is not considered to be good practice to save calculations. Better to recalculate whenever and wherever required.
IMHO the best way of doing it would be to create a calculated field in the query that the form is based on.

[Bob Fitz]

Sorry I missed your post #5

How would I re-calculate so the value get's saved in my table?

You don't. Recalculate whenever and wherever needed

[Bob Fitz]

The following link may be of interest to you: http://allenbrowne.com/casu-14.html