Subform - summarizing data

[si013]

Can anyone help. I currently have a Subform (datasheet view) and i have three fields summarizing the data,
=count("*")
=avg([turnaround])
=sum([turnaround])

Once the form has been refreshed, i reference the three fields within VBA and i assign the values to three variables. But whenever the event is started, the variables are always set to 0. If i put a break point in the code and F8 through it, it will assign the values correctly.

Have also tried to refer to these field from the main field, but still if you let VBA it will just leave the fields blank, but again if you step through with F8 it will work?

Any ideas?

 

[PHV]

Are these 3 fields in the header or footer section ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya si013 . . . . .

[blue]But whenever the event is started, the variables are always set to 0. If i put a break point in the code and F8 through it, it will assign the values correctly.[/blue]

This is exactly what should happen unless your using Static variables.

Can you post the event/routine?

See Ya! . . . . . .