using sum fields to creat an event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an event on the basis of a sum field., however, it
seems that when using ON Open the form is opened before the field is actually
summed always giving me a zero answer in the field. It doesn't matter which
event procedure I use the answer is always zero even though the variable I am
using gives me the right total.

If anyone has the answer as to where I should place the coding I would be
very grateful

Thanks
 
Atlas,

Did you try the Load event of the form. If you use the Load event, and
the value of your calculated control is still 0 at that point, try
putting this line at the beginning of your procedure...
Me.Recalc
 
I am trying to create an event on the basis of a sum field., however, it
seems that when using ON Open the form is opened before the field is actually
summed always giving me a zero answer in the field. It doesn't matter which
event procedure I use the answer is always zero even though the variable I am
using gives me the right total.

If anyone has the answer as to where I should place the coding I would be
very grateful

Thanks
Click to expand...

The form's Current event might be more practical, though I'm not sure
how you're doing the sum or what the Recordsource of the form might
be.

John W. Vinson[MVP]
 
Back
Top