I have a button on a form that opens a second that contains a (referenced) subform. I want to create a new record in this subform where I will insert the related fields. I am having difficulty opening this new record in the subform. I open the parent form, focus the subform, ...
* Form1(Father) SubForm1(son) *
* master field=[Form1].[Id] *
* son field=[SubForm1].Form![Idd] *
...
In the Form0, button:
DoCmd.OpenForm "Form1"
...
In the Form1('open' event)
Forms![Form1]![SubForm1].setfocus
DoCmd.GoToRecord , , acNewRec
Forms![Form1]![SubForm1].Form![Idd]= Forms![Form1].[Id]
I am not able to create a new record in SubForm1, thank you to anyone who can help.
* Form1(Father) SubForm1(son) *
* master field=[Form1].[Id] *
* son field=[SubForm1].Form![Idd] *
...
In the Form0, button:
DoCmd.OpenForm "Form1"
...
In the Form1('open' event)
Forms![Form1]![SubForm1].setfocus
DoCmd.GoToRecord , , acNewRec
Forms![Form1]![SubForm1].Form![Idd]= Forms![Form1].[Id]
I am not able to create a new record in SubForm1, thank you to anyone who can help.