Subform focus on Add

[Ed Finley]

I have an "on current" event on a main form setting the focus on a field in
a subform. How would I cause it to set the focus on the bottom of the
records in the blank add record field? In other words I want to have the
subform as if oppend with the "acAdd" parameter.
Thanks,
Ed

 

[Ken Snell \(MVP\)]

After you have set focus to that control in the subform, run one more code
step:

DoCmd.RunCommand acCmdRecordsGoToNew

 

[Ed Finley]

That did it. Thanks.
Ed

After you have set focus to that control in the subform, run one more code
step:

DoCmd.RunCommand acCmdRecordsGoToNew