Control "what gets the focus" when a form opens?

[GraeagleBill]

I tried this statement in the OnOpen event, Me.Form.SetFocus, wanting to give focus to the first line of a continuous form. However, the control that gets the focus is the first control in the first line, which of course, triggers the OnGotFocus event for that control. I think it would be something akin to where the focus "lands" when the OnCurrent event fires as one navigates to another record of a continuous form.

[June7]

Form cannot get focus when there are active controls. A control gets focus.

[Missinglinq]

...I tried...wanting to give focus to the first line of a continuous form...

...I think it would be something akin to where the focus "lands" when the OnCurrent event fires ...

First off, a 'line,' which is to say, a Record, never gets Focus; only Controls on the Form gets Focus, unless the Form is devoid of any Controls that may receive Focus, as June7 said; then, and only then, can the Form, itself, receive Focus.

Secondly, when the OnCurrent event fires, the Focus 'lands' on a Control on the Current Record. If the Current Record is the first Record, when the Form opens, it 'lands' on the Control that is first in the Tab Order for the Detail Section of the Form. For all other Records, the Control that gets Focus, when moving to another Record, is the Control that last had Focus on the previous Record.

Linq ;0)>

[GraeagleBill]

Yes, a lesson well learned. Since it was convenient and desirable to give the user an added function with this form, I added a command control to the header section of the form and set the focus to the command control in the form's OnLoad event.

Thanks for all the help and education about initial focus on continuous forms.

Bill