Adding new record to subform on main form load

[tsn.s]

Hi

I am trying to add a new record to a sub form when the main form is opened via a button on a menu. I have a similar function on another form, but this is just adding a new record to the main form when it is opened by a button on a menu. After much experimenting I still haven't been able to create a piece of code that adds a new record to a sub form when the main form is opened. Any help is much appreciated. Thanks.

[pbaldy]

I would expect you could use the same method that worked for you, adjusting for the subform. What did that code look like? Personally, I would normally add a record to the underlying table, and requery the form.

[tsn.s]

Thanks for the reply pbaldy. This is the code I have for my other form:

Private Sub cmdNewLearner_Click()

    DoCmd.OpenForm "main_learner_form", acNormal, "", "", , acNormal
    DoCmd.GoToRecord , "", acNewRec


End Sub

When I change it to try and refer to the sub form it tells me that the form doesn't exist.

[thanosgr]

This is how i open my forms

Private Sub openformcmd()
DoCmd.OpenForm "Protocol", acNormal, , , acFormAdd

DoCmd.GoToRecord acDataForm, "Protocol", acNewRec
End Sub

[pbaldy]

GoToRecord lets you specify the form, but you have to use the syntax for a subform:

Forms Refer to Form and Subform properties and controls