Starting in Subform

[damutech]

I made a form (My_form) with subform (sub_form) and when open main form cursor is in the first (tab = 0) field of the main form, but I want that it is in the first (or desired - for example Name) field of the new record of subform .

How can I do this?
Thanks.

 

[RuralGuy]

Welcome to Access World Forums. Setting the focus to a control on a SubForm is a two step process. In the OnLoad event of your form you first set the focus to the SubFormControl and then follow that by setting the focus to the control on the SubForm.

Me.SubFormControl.SetFocus
Me.SubFormControl.Form!ControlName.SetFocus