updating value in form

[Neil via AccessMonster.com]

i am trying to create a form which is a register, i have fields monday, tues
etc and i have a field called actual which i want to store the days that the
people are in, i need this to happen everytime the record is updated

heres what i have

Private Sub Form_AfterUpdate()
Me![Actual] = Abs(Sum([Monday])) + Abs(Sum([Tuesday])) + Abs(Sum([Wednesday]))
+ Abs(Sum([Thursday])) + Abs(Sum([Friday]))
End Sub

this says sub or function not defined which refers to the sum function

thanks in advance Neil

 

[Guest]

There is no Sum function in VBA. Is this a continuous form or a datasheet
you are trying to sum up multiple rows?

 

[Guest]

I'm sorry, Neil, but I don't think I have an answer for you. I am not the
best with continuous forms. Perhaps someone more knowedgable in that area
can help.

This is a continuous form

There is no Sum function in VBA. Is this a continuous form or a datasheet
you are trying to sum up multiple rows?

i am trying to create a form which is a register, i have fields monday, tues
etc and i have a field called actual which i want to store the days that the

[quoted text clipped - 10 lines]

thanks in advance Neil