Reaching a new record in as sub form

[F6GGR]

Hello,
Here is my problem: i have a form with a sub form (they are linked). When I
open the form, I would like to reach a new record in the sub form, with
macro or VBA. I have found an "home made" solution by using a lot of TAB
sendkeys on the "On open" event. It Works but I guess I could do better.
Thank you.

[Steve]

If your subform is bound to the table you wish to add a record to, you
can use Form_frmName.GoToRecord,, acNew to create a new record and set
the subform's focus on it.

[Steve]

If your subform is bound to the table you wish to add a record to, you
can use Form_frmName.GoToRecord,, acNew to create a new record and set
the subform's focus on it.

[F6GGR]

Thank you Steve, I will try.
"Steve" <th*********@gmail.com> a écrit dans le message de news:
11**********************@o13g2000cwo.googlegroups. com...

If your subform is bound to the table you wish to add a record to, you
can use Form_frmName.GoToRecord,, acNew to create a new record and set
the subform's focus on it.

[F6GGR]

Steve,

I tried but dis not succeed ! I tried your code and at last the following.

Here is the code I made for the "on opening" event of the form, SF is the
name of the control containing the subform called SForm (the subform is
bound to a table)

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord acDataForm, "SForm", acNew
End Sub
I tried differents solutions not very different of this one but most often
the message says something like "The form is not open, so it is impossible
to do anything"

What is wrong ?
"F6GGR" <no****@wanadoo.fr> a écrit dans le message de news:
43***********************@news.wanadoo.fr...

Thank you Steve, I will try.
"Steve" <th*********@gmail.com> a écrit dans le message de news:
11**********************@o13g2000cwo.googlegroups. com...

If your subform is bound to the table you wish to add a record to, you
can use Form_frmName.GoToRecord,, acNew to create a new record and set
the subform's focus on it.