Form will not update calculations

C

Cbeckwith

I have three calculations in a group header, update fine on closure of form
through a cmdbutton, but if I want to create a new record through a
cmdbutton, a refresh or a requery will not update the calculations. I either
want to do on the form events or the button events?
How do I fix?
 
J

John W. Vinson

I have three calculations in a group header, update fine on closure of form
through a cmdbutton, but if I want to create a new record through a
cmdbutton, a refresh or a requery will not update the calculations. I either
want to do on the form events or the button events?
How do I fix?
Click to expand...

Hard to say for sure, without knowing how the calculations are being done; but
at a guess a line

Me.Recalc

in some appropriate event (the AfterUpdate events of the controls on which the
calculation is based perhaps) should help.
 
Top