How do you recognize a change in the value of a calculated control?
The normal events such as Dirty don't seem to work, unless I
physically interact with the control in some way.
My problem is this, I have several contols which provide subtotals
from 10 forms. When a value in one of these forms is changed, which
updates the control value, I want it to requery a the record source of
another (11th) subform.
I've tried requerying the data in the 11th form by using the Dirty
event on each of the 10 forms, the problem is that the query runs
behind the change. In other words, the query only picks up the change
after a second change is made. None of the other events seems to work.
I created a recalc button on the form to manually requery the data but
would like the updates to be seemless.
The trigger is a change to in the value of the caclulated control but
I can't seem to get the application to recognize a change has occured.
Thanks.
J.