Asger Blond
ab-mi at post3.tele.dk
Tue Feb 7 16:31:35 CST 2012
You pointed me to a new testing: and the rst clone actually changes when the record on the form changes - that's completely new to me! / Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af William Benson Sendt: 7. februar 2012 23:08 Til: Access Developers discussion and problem solving Emne: Re: [AccessD] RecordsetClone and Bookmark Yeah thanks. I don't have Access or I would have tested. But I am still curious about rst. (Object variable ). I don't think it changes when the form is changed. If not then.... then.... well I don't know then what, nor why I brought it up. <vbg> On Feb 7, 2012 5:03 PM, "Asger Blond" <ab-mi at post3.tele.dk> wrote: > I can confirm that the recordsetclone inherits the record order of the > form at the time the clone is created. > > / Asger > > -----Oprindelig meddelelse----- > Fra: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] På vegne af William Benson > Sendt: 7. februar 2012 22:23 > Til: Access Developers discussion and problem solving > Emne: Re: [AccessD] RecordsetClone and Bookmark > > Nothing to contribute except to say I really am interested in how this > thread turns out. And you left clone off the word recordser Asger... don't > make the clones mad. > > By the way what about when a form is sorted contrary to the > recordsource.... I assume (based on an answer I got from one of the kind > folk here ) that recordsetclone is going to always have records in the same > order as the form at the time the property is "read". If you assign it to a > variable however I am not sure that sorting the form affects the variable. > On Feb 7, 2012 4:08 PM, "Asger Blond" <ab-mi at post3.tele.dk> wrote: > > > 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 > > > -- > 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