Animation problem

Help!!
I have an application that executes a stored procedure on an SQL server and returns a record set which populates some text fields on a form. I want to have an animation play (or a progress bar) for the user while the stored pocedure is being executed waiting for the return of the record set. I have tried using the animation control but it does not work. When I execute the stored procedure the animation does not play. (It seems to hang)
Thanks in advance for any help.

Place a "DoEvents" before your animation call.

If that doesn't work, I'll post the code for a progress bar.