Form will not update calculations

  • Thread starter Thread starter Cbeckwith
  • Start date Start date
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?
 
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.
 
Back
Top