Open and Set Focus to another Form On Load

[BigJimSlade]

Hi, Big Jim here....

Any ideas on how to load and setfocus to a new form during the on load event of another form?

I load and set the focus, but then the on load event of Form 1 finishes running and the focus returns to Form 1.

Any thoughts? Thanks in advance,

Big Jim

(Access 97)

 

[BigJimSlade]

Private Sub Form_Timer()
Me.TimerInterval = 0
If blnOpenLoad = True Then
DoCmd.OpenForm "frmAudit_Load"
End If
End Sub

Set Form 1 timer to something and have a variable in the on load event determine if the new form needs to be opened. The timer runs, turns the timer off, and if need be, opens the form.

Big Jim