Calculating Txt Boxes help

[QuietRiot]

I have a form with 3 txt boxes. Also a table with the 3 fields.. Number of updates, Number of Errors and Number Correct.

I want it so number correct is the calculation of Number of updates minus number of errors on my form. I know in the control source I can put =[Text1]-[Text2] and that works..

but how can I get it so it gets added to the table where control source sould be the field name.


Thanks,

 

[pbaldy]

Generally speaking, you shouldn't store calculated values. If you must:

http://support.microsoft.com/kb/209172/en-us