I do some updates to data displayed on a split form, data is selected on the datasheet view and updated on some text boxes which ar unbound. After I click the update button the datasheet view scrolls to the first record instead of remaining on the record previously selected. I use the code below to keep the focus on the record selected but it does not work.
.FindFirst ("[MAP_ID] =" & tmpID)
If Not .NoMatch Then
Me.Bookmark = .Bookmark
tmpID is the correct record id in it does execute Me.Bookmark.... but still scrolls to the top, please help