Setting Focus to a New Row in a Datasheet Subform 1

[Genimuse]

While subform problems are many, I tend to have pretty good luck if the subform is in datasheet view.

However, many times the amount of data in the subform is enough that the subform needs to vertically scroll. The vast, vast majority of the time, though, the user is going to want to add a new row to the subform.

Is there a way to set the focus of the subform to the last row -- the "new" row -- of a datasheet, that anyone can think of?

 

[PHV]

Something like this ?
Me![subform control].SetFocus
DoCmd.GoToRecord , , acNewRec

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Genimuse]

ROCK! You are such the man! Thanks!

 

[Genimuse]

Oh, and that makes perfect sense. I am officially somewhat ashamed to have missed it.