Set bookmark at new record position

[TTThio]

Hello,

Does anybody know how to set a form bookmark to the new record position?

I have a form with datasheet view. I would like to have my record selector positioned at the last line where you can start adding record.

So far, I've tried to do :

set rs = me.recordsetclone
rs.move 1,adbookmarklast
me.book = rs.bookmark

rs.close


the record selector is still in the first position.

Why is it not moving to the specified record?
Any idea?

Thanks a lot.

 

[TTThio]

Sorry, I just find another way of moving through records in a form without setting recordset.

However, I don't really know how to write the syntax correctly,

Docmd.GoToControl Subform
Docmd.GoToRecord SubformField,,acNewRec

Can someone help me with writing the correct syntax for the subform so that it will be recognized?

Thanks,
Tin Tin

 

[Aivars]

docmd.GoToRecord ,,acNewRec