Setting CurrentRow/Record in a datasheet

[Savita]

Hi,

Is there a way to programatically set the current row in a datasheet(subform) (without clicking the row)?Pls let me know.By default,the first row in the subform gets set as the current row.What do I need to do if I had to set it programatically to, say 4th row?

Thanks,
Savita

 

[Moniker]

I wonder what DoCmd.GoToRecord might do...

I bet there is a way to use that to make Access go to a specific record...

Maybe there's a explanation and example in Access help...