[AccessD] RecordsetClone and Bookmark

Asger Blond ab-mi at post3.tele.dk
Tue Feb 7 09:29:07 CST 2012


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	




More information about the AccessD mailing list