disable dsum field with button

[tagteam]

I use dsum to calculate the sum of values in another table. The problem is some users don't like it because it takes some time to calculate and they want to scroll through the records faster. These users don't even look at the value in the dsum field. Is there a way to assign code to a button that will disable that unbound element so it wont run the calculation as they scroll through the records in the form?

I would like to have a little button right by the field and if it is too slow the user can click the button, disable the dsum and then scroll through the records quickly and then click the button again when they want to see the dsum calc.

Thanks

[pbaldy]

Untested, but try:

Me.TextboxName.ControlSource = ""

[tagteam]

I got around to trying that and it doesnt really work. I think it just sets the current value to be blank but as you scroll through it continues to try to calculate.

I would like a way that stops the calculation so scrolling can be faster.
Thanks

[June7]

Could do the opposite. Have a button that will give the total when requested

Code in the form OnCurrent event to remove value if any:
Me.TextboxName = Null

Code in the button Click event:
Me.TextboxName = DSum(...)

Or forget the button and always report the total with the OnCurrent event:
Me.TextboxName = DSum(...)

[tagteam]

Ahh, yes i already tried that. The one that wants it enabled is the boss, the ones that don't are not. I am sure you can see the quandary. I actually asked the boss if we could switch it but he uses it a lot and said it didn't bother him.
I suppose i can also just copy the form and make a different one for the other users but I was doing that before and it was causing a lot of update headaches.

[June7]

I edited my post as you were posting and you might not have seen the edit. Read again. See if the last option runs faster.

Separate forms should not be necessary.

[pbaldy]

I'll stay out of the kitchen.