Thanks for responding Tom, I see your posts all the time and respect your input. I did try it with the ADO recordset. That's when I finally gave up, posted this thread and went back to my old habits. Of course that works fine, but then I am concerned about the references and future support, etc. I read everything about bookmarks. VBA Help seems to suggest that the bookmark property can be used with ADO.recordset but I couldn't get the object variable to refer to a "Recordsetclone-Like" recordset in order to use it.
Perhaps I haven't explored the proper Methods of the ADO.Recordset object. I have only just scratched the surface of this ADO thing, so I presume there is something I am not getting that will become apparent once I get more familiar with it. Dean --- In [email protected], "Tom Oakes" <[EMAIL PROTECTED]> wrote: > > I always do this via DAO out of force of habit. The ADO recordset does have > a bookmark property, which I think will work the same way. > > Change your recordset declaration to ADO and see if it works. > > Tom Oakes > Personal PC Consultants, Inc. > [EMAIL PROTECTED] > 503.230.0911 (O) > 402.578.2648 (C) > 512.727.9497 (F) > > > > _____ > > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of dsdavids > Sent: Friday, January 20, 2006 7:48 AM > To: [email protected] > Subject: [AccessDevelopers] I don't get ADO > > > I recently resolved to move beyond Access97 and I just don't get ADO. > I see how to work with ADO recordsets when referencing tables, sql and > creating new objects but what if I just want to move to a certain > record in form? I use Recordsetclone and Bookmark properties to find > and make records current with a DAO.Recordset object and I cannot find > a comparable way to use the ADO methods with forms. Every example and > reference I find seems also to go back and explicitly declare the > DAO.Recordset variable. > Is there no simple and proper way to do this without DAO? > > Dean > > > > > > > > Please zip all files prior to uploading to Files section. > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ > Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
