Refresh controls without using a button

[BigBlueScreen]

Hi,

I have 9x contols on a form that after updated I would like the variance and total columns to update. I used the following code in each of the 9 controls..

V1.Requery
CapTotal.Requery

Only the top row I can get to work; and this only works for variance.

Any help would be GREATLY appreciated.

Jd

 

[frozedog]

I believe that Me.Recalc should work for you