Message to appear but not stop macro

[spock1971]

Hi all. Can't seem to find a similar thread although I'm sure there must be one.

I have a macro that runs update queries when exiting the database. What I'd like to do is display a message whilst the updates are running. However, I only seem to halt the macro until the user clicks the ok button on the message box.

Any ideas?

Cheers

 

[KeithG]

Create an unbound form with a label with your message on it. Then open your form in your code. You can also close the form at the end of your procedure.