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_subf orm.Form.Date.S etFocus
DoCmd.GoToRecor d , , 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_subf orm.Form.Date.S etFocus
DoCmd.GoToRecor d , , 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 CommandNewSubFo rmRec. SubFormName is the name of the
subform....chan ge it to your subform name.

Private Sub CommandNewSubFo rmRec_Click()
Me.SubformName. SetFocus
DoCmd.GoToRecor d acActiveDataObj ect, , acNewRec
End Sub

[Deano]

Salad wrote:

Me.SubformName. SetFocus
DoCmd.GoToRecor d acActiveDataObj ect, , acNewRec

Salad, I love you man. That works!