>> I have the following code
>> Set db = DBEngine.Workspaces(0)(0)
>> Set rs = db.OpenRecordset("AddressBook", dbOpenTable)
>> rs.Index = "companyAZ"
>> rs.Seek "=", closeit
>> It successfully finds the record but I'm not too sure how to get the data
>> control to point to the found record. I tried
>> Set data1.recordset = rs
>> but that didn't work as the data control stayed at the first record and
>> not the found one.
>> Can you help me?
>> Stuart A Hill
>Try using the data1.recordset.findfirst. I have problems using the seek method. The
>findfirst will move the pointer to the first record. From there use the
>data1.recordset.findnext, findprevious, or findlast to move to any record.
(1) make sure you are using a table object (Very inportant)
' --- set the index
RS.Index = "indexname"
' --- do the seek
RS.Seek "=", Var2Look4$
' --- check fo a match
If RS.NoMatch Then
==Steve DeGeorge SR