Using Macros to store calculated values in a database

[Guest]

Hi

On my Access form I have 3 groups that I am making totals
for:
Q1-10...Q11-15...Q16-20

I have 3 total boxes at the end of these questions...I
can add Q1-10 and have the result display in the box on
the form...same for the other 2 groups.

BUT...I am trying to save these calculated values to 3
fields in a table...Fields:
TotalScore1...TotalScore2...TotalScore3

I made a macro for the 1st group (Q1-10)
Action...SetValue
Item...TotalScore1
Expression...Q1+Q2+Q3

Then set the AfterUpdate property to each textbox in Q1-
10 to Macro1...and it states to set the OnCurrent
property of this form to that macro's name as well...

When I do that it works fine for the 1st group...but when
I create 2 other macros for the other Q groups...it
doesn't save the value on the form or to the field in the
table...and what do I do with the OnCurrent property for
the form??

Can't enter all 3 macros there...??

Thanks!