Form w/ running total blinks upon opening... too slow?

[MushMouse]

I use DSum to create a running total in a form.
The form blinks 5 times before opening & this is disturbing to the user.
When there are only a few records, this in not noticeable, but when there are over 1,000 records, it is.

Any advice on how to correct this?
Is there another way to create a running total in a form that has other fields that need to be updateable?
Could the problem be the DSum? I open other forms with 20,000 records and don't have this problem, but those forms don't have a running total....

 

[TheAceMan1]

How are ya MushMouse . . .

Do you have any code in the forms [blue]OnLoad[/blue] or [blue]OnCurrent[/blue] events?

Particularly [blue]OnCurrent[/blue] as this event can easily become [blue]recursive . . .[/blue]

See Ya! . . . . . .