Value in field changes in record I go to to what it is in record I am leaving

[Serendipityww]

Included on a form are 3 fields which contain letter grades for tests. And then three other fields which change the letter grades to number grades. If I enter or change a value in, say, the Test1 field of record 13, then asI cycle through the records after that, they change the value in their Test1 field to the value I entered in record 13. This problem is true of many of the fields on this form. I have a very similar form that does not have this problem. (I actually madethis form by doing a Save As from the working form.) These particular values do not get stored in a table. They are used to arrive at a final grade which does get stored in a table. Why do the values I enter not "stick"?

 

[AlanS]

I'd need to see the database to track this one down, but I suspect that the field in question is storing its value in a global variable, rather than a table field, and that is why it is carrying through from one record to all the others.

 

[Serendipityww]

Still need more help, please. I now have the form based on a query which is based on 4 tables. The values should store back in the Grading table, but I still have my original problem. Because I couldn't update via the form, I set the Recordset Type to Dynaset(Inconsistent Updates). Could this have anything to do with it? Thanks.