In Subform set focus to the new record

[qshaz]

I have a subform and a button called add new record. When the main form is also a new record, and someone clicks on the subforms addnew record button, naturally they can see the new record. The subform is a continous form and takes a small space of the main form. So when there are many new records, and someone clicks add new record, the focus does not go to the blank new record, and they have to scroll down to see this. How do I do this?

Thanks
Shazia

 

[kpereira]

I would simply setfocus on the field in that record you wish to be in.

For example,

DoCmd.GoToRecord , , acNewRec
Me.EmployerName.SetFocus

This brings the focus in the new record to the EmployerName field.

I hope that helps.

Karen