Adding 'scores' using text boxes

[RebeccaMinAR]

I have a survey I'm using to determine engagement levels in a project. It has
several questions in a combo box and the 'score' each question is given. I
have a query pulling the score into the text box next to it (I have it in the
"On Mouse Move" event procedure - any suggestions on which one I should use,
or if this is OK? It working, but seems a little awkward). Now I need to
total those scores and come up with a final determination - which I'd
eventually like to transfer back to another form when I close the form (which
I think I can figure out, but again, any help is appreciated). How can I
easily total numbers from a group of text boxes? Thanks for your help!

 

[Jeff L]

Put =Sum([YourTextBox]) in your total textbox or if you are adding
vaules on the same record, =[Field1] + [Field2] + [Field3] and so on.

Hope that helps!

 

[RebeccaMinAR]

Thanks, Jeff - who knew I could do something so obvious. <G>

Blame it on Friday braindead.

Put =Sum([YourTextBox]) in your total textbox or if you are adding
vaules on the same record, =[Field1] + [Field2] + [Field3] and so on.

Hope that helps!

I have a survey I'm using to determine engagement levels in a project. It has
several questions in a combo box and the 'score' each question is given. I
have a query pulling the score into the text box next to it (I have it in the
"On Mouse Move" event procedure - any suggestions on which one I should use,
or if this is OK? It working, but seems a little awkward). Now I need to
total those scores and come up with a final determination - which I'd
eventually like to transfer back to another form when I close the form (which
I think I can figure out, but again, any help is appreciated). How can I
easily total numbers from a group of text boxes? Thanks for your help!

 

[Klatuu]

if you are saying that you will add the score from the combo selection to the
score in the text box, the combo's After Update event is the best place to do
that.

Me.txtTotScore = Me.txtTotScore + Me.cboScore

Now, the trick is to get Me.txtScore back to 0 when you start a new record.
Use the form Current event

Me.txtTotScore = 0