Creating calulated controls

[dogman01]

I have a field in my table called "testcalc" and I want it to be calculated but when I put the calculation in it's control source it's data does not stay because it's lost it's contol source. How do I keep the control source "testcalc" yet build the calculation into it

 

[dkinley]

Duplicate thread, the problem is being addressed on the thread ...

http://www.access-programmers.co.uk/forums/showthread.php?t=162065


-dK

 

[pbaldy]

Generally speaking, you shouldn't store a calculated value. If this is one of the rare exceptions:

http://allenbrowne.com/casu-14.html

 

[Mike375]

If you want to do calculations the two common ways are either a query or unbound text boxes.

For example, a table might have a field for miles driven and the amount of petrol to fill up. Either a formula in an unbound text box or a calculated field in a query would then display "miles per gallon"

 

[fsshome]

Generally speaking, you shouldn't store a calculated value. If this is one of the rare exceptions:

http://allenbrowne.com/casu-14.html

Thank you very much because it helped me a lot! Thank you again!

 

[pbaldy]

Welcome to the site fsshome; glad it helped you out.