I am presently accessing an Access DB using DAO. With the recordset open I would like to search through the already open recordset, choose a record, and fill my text boxes with the associated information from the rs. What would be the easiest way to do this. This is how I am trying to do it now:

SearchStr$ = Search.Text
rs.Index = CompName
rs.Seek "=", SearchStr$
If rs.NoMatch Then
MsgBox "No match note", vbInformation
End If

Obviously this will not fill the associated text boxes but I cannot get it to search the recordset at all. I have the DB indexed on the CompName column in the table. Always get a run time error 3251.

ANY HELP WOULD BE GREATLY APPRECIATED!