Go To New Record

D

Don

I have a form which has a subform and that subform has its own suborm. When
I'm down into the subform's subform and have finished inputting my data, I
want to go to the form's subform and have it go to a new record. I know how
to navigate to the form's subform, but I can't seem to get the form's subform
to go to a new record. Any help would be appreciated.
 
K

Ken Snell [MVP]

How are you navigating to the subform? by code?

Perhaps this code in the subform's subform will work for you:

Me.Parent.SetFocus
Me.Parent.Recordset.AddNew
 
Top