Starting in subform

[damutech]

I made a form with subform 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 field of the new record of subform.

How can I do this?

 

[ddiamond]

I haven't tested this, but the following might work:

'In the Main form
Sub Form_Load()
  subform.setfocus
End Sub

This is assuming the first field on the sub-form also has a tab_index = 0.

 

[Zion7]

if ddiamond's doesn't suffice, maybe reference the control itself?

Sub Form_Load()
Me!subform.Form!txtName.setfocus
End Sub