[AccessD] bound to be my problem

ADO recordset clones aren't the same kind of an animal as DAO
recordsetclones, which may be your biggest problem.  In XP, there is
built in support for some basic DAO and ADO functionality even if
neither reference is checked, so you could continue to use the kind of
DAO code from earlier versions and it will work.

Charlotte Foust


-----Original Message-----
From: Francisco Tapia [mailto:fhtapia at gmail.com] 
Sent: Monday, January 24, 2005 1:58 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] bound to be my problem


I have been beating at this all morning.. while I can get the recordset
bookmark to move correctly in the following "bound" subform, I can't
seem to get the record selected so that the end user can use it.

any ideas?

CODE snip:::

Dim rsInProcess As adodb.Recordset
Set rsInProcess =
Me.frm_007N_sbfrmINprocess.Form.Recordset.Clone(adLockReadOnly)
rsInProcess.Find "RRID = " & Me.txtRRID, , adSearchForward,
adBookmarkFirst Me.frm_007N_sbfrmINprocess.Form.RRID.SetFocus
   If rsInProcess.EOF = False Then
             Found = True
             Me.frm_007N_sbfrmINprocess.Form.Recordset.Bookmark =
rsInProcess.Bookmark
  End If
rsInProcess.Close
Set rsInProcess = Nothing

::::END CODE snip
-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com