[AccessD] RecordsetClone and Bookmark

 You don't move the forms cursor.  Your finds are invisible to the form and
the user.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
Sent: Tuesday, February 07, 2012 10:29 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] RecordsetClone and Bookmark

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	


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com