A2K - create new record in subform from main form

[Deano]

Thanks for the replies to my previous post. So while I'm on a roll
here's another plea for help.

I simply need the code for a button on the main form that will create a
new record in the subform. Hopefully this will always force the new
row to be selected (i.e it scrolls to the bottom if needed).

Extensive googling has given me many threads and the clearest answer
seems to be set focus to the subform and then create the record;

Forms!frmStaff!frmDetails_subform.Form.Date.SetFoc us
DoCmd.GoToRecord , , acNewRec

This simply creates a new parent record and the control doesn't get the
focus.

Any help?

Thanks
Martin

[Salad]

Deano wrote:

Thanks for the replies to my previous post. So while I'm on a roll
here's another plea for help.

I simply need the code for a button on the main form that will create a
new record in the subform. Hopefully this will always force the new
row to be selected (i.e it scrolls to the bottom if needed).

Extensive googling has given me many threads and the clearest answer
seems to be set focus to the subform and then create the record;

Forms!frmStaff!frmDetails_subform.Form.Date.SetFoc us
DoCmd.GoToRecord , , acNewRec

This simply creates a new parent record and the control doesn't get the
focus.

Any help?

Thanks
Martin

See if this gets you close. I created a button on the main form with
the name CommandNewSubFormRec. SubFormName is the name of the
subform....change it to your subform name.

Private Sub CommandNewSubFormRec_Click()
Me.SubformName.SetFocus
DoCmd.GoToRecord acActiveDataObject, , acNewRec
End Sub

[Deano]

Salad wrote:

Me.SubformName.SetFocus
DoCmd.GoToRecord acActiveDataObject, , acNewRec

Salad, I love you man. That works!