I have a form that contains a subform that performs six dsum calculations. It is a tabular form that has four of the dsums in four different objects in the detail part of the form. Two of the dsums are in two different objects on the form footer. I have to check if the results of the dsums are numeric before I display the results. Otherwise, I display zero.
The problem is the form doesn't seem to get all of the results from the dsums before it displays the data. It takes some of the dsums to be non numeric and displays zero. If I do something to trigger a recalc, the results come out correctly. What am I missing and how do I correct this without too much of a delay to the user?
Thanks.
The problem is the form doesn't seem to get all of the results from the dsums before it displays the data. It takes some of the dsums to be non numeric and displays zero. If I do something to trigger a recalc, the results come out correctly. What am I missing and how do I correct this without too much of a delay to the user?
Thanks.
