After update runs before calcuation

  • Thread starter Thread starter Ken Ivins
  • Start date Start date
K

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"?
 
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.
 
Wayne,

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

Thanks,
Ken
 
Back
Top