Processing info Form

[Guest]

Hello.
I have a bd that imports a table from another database and this action may
take a while. I have a form with a rectangle object that works as a progress
bar.
What i'd like is that while the import action is running, this form stays
opened and executing the vba code on it.
When the import action stops, the form will close.

Is this possible?

Thanks

Luis

 

[Guest]

Sure, just make the last line of code:
DoCmd.Close

 

[Guest]

Ok, but the import action is triggered from another form.
My question is if it is possible that when a user clicks on a button to
import a table, the import begins and also the form opens. When the import
action ends the form with the progress bar stops executing and closes.

Can you help me?