Automatically go to new record in subform?

[afs24]

I have a form with a subform. When I select a name on my form I want my subform with all that persons data to go to a new record. I don't want the user to have to scroll thorugh all the data when all they want to do is enter a new record. Any suggestions?

 

[tails]

well you can just tell it to move to the last record in the field then all they need to do is click on the right arrow once and they will be at the new record

[Form].Recordset.MoveLast

change [form] to the name of the form that you want to use should work