Set Focus to TextBox

[crimedog]

I have a DB that opens to my Log In Form and Minimizes the Access Program.
I need the focus to go to the Log In Form TextBox TxtUserName
This is what U have:

Private Sub Form_Load()
DoCmd.RunCommand acCmdAppMinimize
Forms("0Frm_LogIn").SetFocus
End Sub

I have tried various versions and adding the set focus to the actual TextBox - no luck



The TabIndex for the TxtUserName is 0 - so it should be first

[John_G]

You don't explicitly reference the control itself, so try doing so:

Forms("0Frm_LogIn")!txtUserName.SetFocus

(Is the name of your form really "0Frm_Login", or is the "0" a mistake?)

[crimedog]

Yeah I had that on the line after

DoCmd.RunCommand acCmdAppMinimize
Forms("0Frm_LogIn").SetFocus
Forms("0Frm_LogIn")!txtUserName.SetFocus

It still does not set the focus

[ssanfu]

FYI - Can't tell if the first character is a zero (0) or an oh (o). If it is a zero, the Access Gnomes can get persnickety when object names begin with a number.