How to Show Totaling Values on Form

[Access_Headaches]

Heres What I'm trying to do:




Team 1

Team 2

Team 3
I______________I I_________________I
Data Entry (yes/No) Show Totals from past Entry


I just don't know how to show the totals in the second area and have them update as new entry's are added. This would be on the form. Please let me know if you need more info.

 

[Steve R.]

One way would be using the "Lost Focus" event to "force" a recalculation when the control is exited. This may be the easiest approach. Another alternative would be the "On Click" event for each textbox to "force" a recalculation. The "On Change" event could also be used, but may require more coding.

 

[Access_Headaches]

http://img832.imageshack.us/i/accesspic.png/

This may help explain better


Will try your idea as well, thanks Steve