Change focus to different form

[Zelandakh]

I was trying to be clever - but I'm not clever enough...

Database is set to open frmStart. This form has an onload property set to:

DoCmd.Minimize
DoCmd.OpenForm DLookup("sMenu", "tblUsersAndGroups", "sUser='" & fOSUserName & "'&quot

(I've cut out the error checking). This opens a form based on the Windows 2000 username. Downside is that the frmStart has the focus, not the next form specified in the openform above.

How can I change the focus?

 

[TPetersonFlorida]

You could try a few different things:

1) close out the frmstart on the onopen of the dlookup form.

2) try to implicitly set the focus such as: forms![myformname].setfocus or maybe me.setfocus

3) open the dlookup form modal or as a dialog