Adding record to a subform from button on main form

[mmitchell]

I am trying to add a new record to a subform from a button on the main form but when I do, the subform's blank new record does not "jump" to the focus like when I click on any of the subform records and hit Insert-->New Record.

Here is what I have on the button:

Forms!F_Parameters!F_Parameter_subform!tbxParameterName.SetFocus
DoCmd.GoToRecord , , acNewRec

 

[Rich]

subFormControlName.SetFocus
someControlOnSubForm.SetFocus
DoCmd.GoToRecord , , acNewRec


so you need to set focus to the subform and then a control on the subform

 

[mmitchell]

Yes, that did it!

Thanks.