Open Form without Focus

[kattatonic1]

I have found tips on the interwebs to open a form without focus by cheating with a tiny text box and putting it first on the tab order. The tip sheets all seem to be pre-Access 2010 though. Does anyone know if there is an official Access way to do this yet?

Happy Monday, folks!

Kay in Toronto


Sunny but still chilly

[ItsMe]

You should be able to set focus on the form itself. You could place the following in the forms On Load event and the form's On Current Event.

Me.SetFocus

If you want the form to open and not be visible you could open the form from another form and then use the Me.Focus in the original form. There is also acHidden and the Minimized properties but this will not work unless you are using the old school "Overlapping Windows" settings.

[kattatonic1]

It wouldn't execute as focus to the form itself rather than a specific object. It was following the tab order.

However, while I was playing with the SetFocus in the form's On Current event, it occured to me that I have an information button on each form where I would do this. So [Information button].SetFocus works great! Thanks, ItsMe. Always happy to be lead to the water.

Kay