Tab Order

[kirstenlargent]

I would like the focus to be on a certain control/field (named "PlaintiffName&quot when I open a particular form. The tab index on the desired control is set to 1, and I've created the following Form Open Event for the form:

DoCmd.Maximize
DoCmd.GoToRecord acDataForm, "frmSubpoenas", acNewRec
Forms!frmSubpoenas!PlaintiffName.SetFocus

For some reason, the form always opens with the DateRecieved field selected even though it has a tab index of 2. What could be causing this or how can I correct the problem?

Thanks.

 

[dvannoy]

Tabindex = 1..that would be the second tab focus..

try TabIndex = 0

0 is the first..

 

[SBendBuckeye]

Is the PlaintiffName control locked? To see what the code is doing, you could temporarily define Got Focus events for both controls and kick your code into single step mode.

One other thing, the On Current code is called after Form Load, perhaps that is tripping you up (in conjunction with prior response)

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!