In MS Access 2003 I did have a Total Text box with the
following statment in the control source
This would automatically sum up the values in the 12 other fieds when one of them was changed.
In Access 2010 this does not seem to work anymore.
Is there a way to do this sum when a field changes. Do I really need VBA to do this or is there a nice trick I can do?
I have about 12 columns like this on one form. Maybe not best design from our perspective, but the user loves it.