Main new rec button for many subforms

[steve1111]

Hello,

I have a form with 5 subforms that all control different aspect of the same work order ID. What i am looking to do is hit a "new" button on the first subform and not only that subform goes to a new record but the other 4 subforms below it as well.

I have tried new record on the 1st subform and then setting focus to the second for a newrec, and so on but no luck.

Thanks for any ideas

 

[steve1111]

I think i found my mistake, i was setting the focus to a control on the next subform rather than the subform itself from the parent form.

I can now set focus to each subform and then docmd.gotorecord,,acnew

 

[SJB67]

you haven't mentioned how the subforms are related to the parent form, but how about making them all Me.yoursubform.DataEntry = True when you hit new record on subform 1?

alternatively docmd.GoToRecord acDataForm,"yoursubform",acNewRec for each?