>My problem is i cant get any code i try to write to total(sum) all of the values in all of the records by Username then automatically insert that total into the next firld (total Points) upon exiting the points entry field on my form.

You can use query I provided to get TotalPoints before you add new record. In the Valid() or LostFocus() of Point field just add Points value to the TotalPoints.