Sum Problem

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

I have got a textbox on a continious form that sums [hour1].
The only problem is that it takes a couple of seconds to sum that field.
Is there a way to sum in VB?
I need to do so validation with the sum, but the way it sets now it looks at
the value before its updated.
 
I have got a textbox on a continious form that sums [hour1].
The only problem is that it takes a couple of seconds to sum that field.
Is there a way to sum in VB?
I need to do so validation with the sum, but the way it sets now it looks at
the value before its updated.
Click to expand...

What's the Recordsource of the subform? How many records? Where is
this textbox and what is its Control Source?

Only one record on a subform is "live" at any one time; it's summing
records that have already been stored in the table and the value in
the record being currently edited. It would therefore be a bit tough
to do this in VB, since it would have to look two places - perhaps a
DSum() on the table, and the value from the currently edited record. I
doubt it would be any faster.


John W. Vinson[MVP]
 
Back
Top