Subform focus on Add

E

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
 
K

Ken Snell \(MVP\)

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

DoCmd.RunCommand acCmdRecordsGoToNew
 
E

Ed Finley

That did it. Thanks.
Ed
Ken Snell (MVP) said:
After you have set focus to that control in the subform, run one more code
step:

DoCmd.RunCommand acCmdRecordsGoToNew
Click to expand...
 
Top