Updating sum of a field

[merry_fay]

Hi,

I'm about to burst into tears & throw my laptop out the window.

I have a form which shows data from a table.

There is a sum cell on the form: Sum([CPU New]) (CPU New being a field in the source table)

After I change the value of one of these numbers in the form, if I then immediately click on the button to run my vba, the Sum([CPU New]) is not updating to the new value. If I click onto a different record first, it's fine.

I've tried using me.requery in my vba to make this update but then the Sum([CPU New]) becomes null!!!!!!!!!!! I've tried refresh too, setting the focus elsewhere.
I'm completely at a loss. All I want is for the cell with Sum([CPU New]) in it to update to the new total.

Any help please?

Thanks

 

[jdraw]

What version of Access are you using?
Is this a bound form?
Can you post an mdb (I don't have acc2007 and can not open accdb) with enough info to show the issue?

 

[missinglinq]

Try Me.Recalc rather than Me.Requery.

Linq ;0)>