Update "Total" Field on Form

[dargo72]

I have a form in which I place scores for various tasks. I also have a "Total" field which I would like to update dynamically when I enter in individual scores.



For the total field, I have the following expression:

=Nz([Newsletter Score])+Nz([Shift Reinforcement])+Nz([Physical Walk Through Pilot])+Nz([Peer to Peer Integration Meetings])+Nz([Follow-Up Communication])

It does update if I goto a new record and come back, however, I would like it to update as folks are entering scores in the individual boxes.

How do I do this?

Thank you,

[Rawb]

You need to add an After Update Event to the fields "Newsletter Score," "Shift Reinforcement," "Physical Walk Through Pilot," "Peer to Peer Integration Meetings," and "Follow-Up Communication." that forces the Total Field to update itself:

Me!Total.Requery

(Assuming the name of your Field is "Total")

[dargo72]

worked perfect, thank you.