Francisco Tapia
fhtapia at gmail.com
Mon Jan 24 15:57:58 CST 2005
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!