I've got 2 subforms, one is a datasheet input screen (5 records) and the other subform shows the average of the five records.

After I update a single recordset in subform 1, I need the subform 2 to reflect the updated average of the 5 records.

Subform 2 is always one update behind.

I am using an After Update in subform1 to recalculate subform 2.

For Example:
Subform 1 has (10, 10, 10, 10, 10)

Change the first recordset to 20 (Data is now 20, 10, 10, 10, 10)
Subform2 average is still 10.

Change the first recordset back to 10 (Data is now 10,10,10,10,10)
Subform 2 average is now 12.

What am I missing?
Thanks in advance.