Refreshing a value - immediately

[PeterDuthie]

Sorry everyone - I have searched for info on this but can't find what I'm after.

I have a subform (Continuous Forms view) which does a simple row multiplication based on a value selected from a combo - the multiplication appears in the sub-total column and the calculation is done in the AfterUpdate()event for the combo. There is a total field in the footer which sums the sub-total column. This works fine except that the total field in the footer doesn't update immediately: it does update when I click on something - the final record seems to do it - but there must be a way to raise a dirty event or something to get the total field to does its stuff immediately.

I forgot to say that the total field is handled with an expression in the control source.

Cheers,
Peter

 

[PaulF]

try sending a Me.Refresh after the change

PaulF

 

[BoxHead]

Paul, where were you three weeks ago when I was trying to do it with Form.Refresh and kept getting kicked back to the first record?

Thanks,

BoxHead

 

[PeterDuthie]

Thanks you very much Paul - me.Refresh doers the job:0)

Cheers,
Peter