Message box with no button

[zrzr]

I have a replicated database, and a starting function which synchronizate the two replica.

Synchronization is a bit long, so I would like to display a message, like "Loading ...", and close it when the synchronization is finished.

So I made a form with a caption, and I call it before calling the synchronization function.

My problem is that after calling the form, the PC is so busy that he can't display the message !! I only see the frame, with the title, but not the message.

I tried some functions, like Idle, but it only work for sql engine, not for VBA code.

SO, what can I do ?

 

[Norris68]

Have you tried a DoEvents immediately after your OpenForm call?

 

[zrzr]

Thanks Norris68, it was what I was looking for !