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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top