Is there a way that I could implement a loading Bar!

[Z1nkstar]

I will test be right back

[Z1nkstar]

added more time but the form still doesnt show up until it reaches 100%

[June7]

Okay, I was switching from Design view to Form view. Now I get what you see. Instead of calling the Sub from Load event, call it from a button Click.

[Z1nkstar]

So where should I move the code?
from a Button Click doesn't say a lot sorry

[June7]

Create a button on form. Select [Event Procedure] in the Click event property. Click the ellipsis (...) to open VBA editor at the procedure. Type or copy/paste code into procedure.