After update runs before calcuation

[Ken Ivins]

I have a textbox on the main form (txbStatmentBalence) that calculates 4
fields from 3 sub forms (two of which are also sum fields that add all
totals if a different check box is checked in the subforms footer).

What I want to do is after I check a check box I look to the
txbStatmentBalence and see if it is "0" if so, then make a label visible.

My problem is that After Update event for the check box looks to the
txbStatmentBalence before it is recalculated to the current data. How do I
get it to hold off until the field is updated and then look to see if the
result is "0"?

 

[Wayne Morgan]

The best way is to perform the calculation in the AfterUpdate code. There
are some ways to work around the timing issue, but they aren't perfect.

 

[Ken Ivins]

Wayne,

That makes sense. Thanks. More coding but it is the right way to go.

Thanks,
Ken