[b][red]This message was edited by mohsinali at 2003-11-15 23:58:24[/red][/b][hr]
Its my first post to this board. I am here with a little problem. Let I have a recordset like this
Dim RS as New Recordset
RS.CusrsorLocation = adUseClient
RS.Open "SELECT * FROM MYTABLE ORDER BY CODE "
Then I move upto some records like this
'Move 50 Records ahead
For i = 0 to 50
Now I search something like this
If RS.EOF Then
MsgBox "Not Found"
Now what this code will do that if the name is found, then the Record will be pointing, or in otherwords will land on to the record whose name field is 'Mohsin', and if not, then it will land at EOF.
But what if I need to point back the Recordset to the location where I was before invoking the Find Method?
I mean any Bookmark or anything like that...?