[AccessD] RecordsetClone and Bookmark

The bookmark allows you to sync the recordset with the physical display without knowing the PKID. 
If you know the PKID then you r method works just fine.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 2/7/2012 10:29 AM, Asger Blond wrote:
> Having a listbox on a form for navigation to a specific record I've always used RecordsetClone and Bookmark like this:
>
> Private Sub lstOrderID_AfterUpdate()
> 	Dim rst As DAO.Recordset
> 	Set rst = Me.RecordsetClone
> 	rst.FindFirst "OrderID = "&  Me.lstOrderID
> 	Me.Bookmark = rst.Bookmark
> End Sub
>
> Now I notice that the code apparently might as well be just:
>
> Private Sub lstOderID_AfterUpdate()
> 	Me.Recordset.FindFirst "OrderID = "&  Me.lstOrderID
> End Sub
>
> Can't remember the reason for using RecordsetClone and Bookmark in this case. Any suggestions?
>
> / Asger	
>
>