Status Bar

I am using a Form as my front end in Microsoft Access. I have a FOR NEXT loop that I want to Display a Status bar when its running. I would also like to add some discriptive text while its running.

I dotn want the status bar to be attached to the form rather pop up when its inthe FOR NEXT loop.

I have been online looking for examples and have come up with message box alert but I have to click the message box every time for it to go away.

I am looking for a nicer appearence....

Anyone have a tid-bits or examples of coding for this.....

THIS IS THE MESSAGE BOX CODE I HAVE: BUT I AM LOOKING FOR A COOL STATUS BAR THAT HAS MOTION OR A PROGRESS STATUS....

For intLoopIndex = 1 To 10

Dim counter
counter = 0
MsgBox "The counter is: " & intLoopIndex

Create a seperate form, and when you enter the for/next have it pop up that form, have a label for status and have a progress bar(Component: Microsoft Windows Common Controls)

How do I make the Second form display a status bar. I know that I can call another form but I am unsure as to how I get a label/listbox etc to actually show a progress bar

Thanks for you response

although i've never done it ... here's some links that may help:

http://www.eggheadcafe.com/articles/20010610.asp

http://www.atgconsulting.com/progressbar.asp

http://www.webconcerns.co.uk/javascript/progressbar/progressbar.asp

Add the component Microsoft Windows Common Controls, it will add a progress bar control for you.


Edit: If you want any help with it or an example, feel free to drop me a line on msn

MSN: vaelfore@hotmail.com

The major problem I am having is that as I go through the FOR NEXT Loop there is a call to another function. If I use a message box I have to click OK everytime it goes through the loop. If I call another Form within the Loop it does not display the whole form untill it loops through 10 times. I am not sure how to code it so the Second form shows up the entire time....

Does that make sense?

Thanks