Update table from unbound field on Form 1

[netrusher]

I have a table with a form. This table collects information
for 17 tennis tournaments this summer. Each person entered
in the tournament can earn points. I have a form that shows
all 17 tournaments. Let's say Sam Jackson has played in 3
tournaments so far. On this form he would have points in
3 locations one for each tournament. I have a total points
field on the form that is a sum of all 17 tournaments.
=[pts-01]+[pts-02]+[pts-03] etc. The name of this field is
TotalPoints. This field is unbound. I also have a field in
the table called TotalPoints. I would like for the field in
the table to equal what the TotalPoints field on the Form
equals but I do not know how to make this happen. Any advice?

 

[ZmrAbdulla]

There are many ways.
1. Set the recordsource of the for to a query with an additional field with the required calculation. This is the best way as the calculted data not to be stored in the db

2. SetValue macro

3. Update Query

....

________________________________________________________
Zameer Abdulla
Help to find Missing people