msg box timing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, I have a msg box that I want to appear when a form is opened. Everything works fine except the timing. As soon as I double click on the form name to open it, the msg box appears, I have to click okay, then the form appears. I would like to have the msg box appear after the form is displayed. I have tried the on open event, on focus, etc for the form and also for the first field.

Any suggestions.....?

Thanks
 
With a little experimentation, I did this in the general declarations:
Dim xTimer As Integer

In the forms open event, I added this
xTimer = 0

Then I set the form timer interval to 500, and put this in the forms
timer event:

If xTimer = 0 Then
MsgBox "Hi"
xTimer = 1
End If

Worked for me - adjust the timer interval to suit your tastes.

Have fun!
 
Back
Top