[AccessD] You Canceled the Previous Operation

And to piggyback on Gustav's reply, the second call to me.RecordsetClone
creates a new clone, it doesn't use the one you just ran a find on.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, September 26, 2007 8:23 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] You Canceled the Previous Operation

Hi Rocky

Try to hold the Recordset:

    rst = Me.RecordsetClone
    rst.FindFirst "PersonID = " & Me.lstShortList.Column(0) 
    If rst.NoMatch = False Then
      Me.Bookmark = rst.Bookmark
    End If
    rst.Close
    
/gustav


>>> rockysmolin at bchacc.com 26-09-2007 17:13 >>>
Dear List:
 
Does anyone know why the code:
 
    Me.RecordsetClone.FindFirst "PersonID = " &
Me.lstShortList.Column(0)
    Me.Bookmark = Me.RecordsetClone.Bookmark

generates an error 2001 - You Canceled the Previous Operation?
 
The value in Me.lstShortList.Column(0) is a valid PersonID.  It happens
on the second line.
 
MTIA
 
Rocky



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