Subform and mainform

[Puru pela]

I have a form on which I've nested one subform in datasheet view to enable me enter data in a one to many relationship tables. Now I've included a comman button on the main form, so that in an onclick event, should take the cursor to a new record on the subform. Any tip will be greatly appreciated

[mbizup]

You need to do two things in the VBA code behind the button:

1. Set the focus on the subform (the same way you would set focus on any other control):

Me.SubformControlName.SetFocus

2. Go to a new record:

Docmd.RunCommand acCmdRecordsGotoNew

[Puru pela]

Great! Thanks a million, I got it.