Jim Dettman
jimdettman at verizon.net
Tue Feb 7 15:16:55 CST 2012
<<the finds certainly make the form show the wanted records>> Once you do: Me.Bookmark = rst.Bookmark But until then, all the manipulation in rst won't be visible to the form or the user. That's the whole point. You can jump forward and backwards all you want, but until you set the forms bookmark property, none of what you do affects the form. 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 04:11 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] RecordsetClone and Bookmark Disagree - the finds certainly make the form show the wanted records, no matter if I use rst.FindFirst or Me.Recordset.FindFirst / Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman Sendt: 7. februar 2012 21:27 Til: 'Access Developers discussion and problem solving' Emne: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com