[AccessD] RecordsetClone and Bookmark

Asger Blond ab-mi at post3.tele.dk
Tue Feb 7 16:06:11 CST 2012


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




More information about the AccessD mailing list