setfocus on form

[dalerguy]

Hi,

I am trying to simply have a form open once my switchboard is loaded. I
used the Docmd.Openform "form1" to open the form. Now I want to set focus
of form1. After reading the docs, I still can't seem to make form1 become
focused upon opening.

I know this is a simple one, but I'm getting frustrated.




Thanks,

Mike

 

[Penguin]

Try this code:

DoCmd.SelectObject acForm, "form1"

Hope this helps.

 

[Dalerguy]

No go... Form1 still opens in the background of the switchboard.

Just to clarify where to place your suggestion:

Private Sub Form_Load()
DoCmd.OpenForm ("Over Due Requests")
DoCmd.SelectObject acForm, "Over Due Requests"

Thanks

Mike

 

[Penguin]

I think you need to place this code in the load event of the
switchboard.