How can I close a msgBox programatically? I have a subroutine that runs several queries to delete and rebuild a set of tables. I am not using forms, just rebuilding tables to do further data analysis. It takes a couple of munites to do, and I wanted to have a message pup up to alert the user. Something really simple like msgBox("Running"). But I would like to message to go away without selecting OK when the update is complete.

Thanks

Hi,

You can create a form to use as a msgbox, give it a public property of the text it must display and then you can use this new form class like a msgbox that you can open and close programmatically.
I'm sure there's an article in the book that does something similar.
An alternative is to use the status bar, however I think it sounds like you want something in the face of the user!
HTH, if not I'll try to help further.

Malc.