Error Running sum in subform

[tanolalano]

Hi all!

I try the running sum that i've find in the faq faq702-5248.
The problem is that when I use the code in a subform the running sum doesn't work. I get #Error in the unbound control.
Then I create a form whit the same origin and the same control to see if I do all corectly. So, running sum in the new form works perfectly.

How do I solve the problem??
Thanks in advance

 

[tanolalano]

Solved...I had 2 field with the same name

 

[TheAceMan1]

tanolalano . . .

The new code for the FAQ has been posted (the main global routine)!

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[maxhugen]

For simple forms/subforms, you can also use

Static total@

Function runSum()
    total = total + Me!amt
    runSum = total
End Function

Set the running sum control's ControlSource to =runSum()

Note that if you're letting the user resort the form, the static variable 'total' has to be reset, as well as when refreshing, requerying, etc.

Max Hugen
Australia

 

[TheAceMan1]

maxhugen . . .

. . . and how would you go about resetting the total?

User can add,edit & delete values and/or records . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: