Using Find in Recordset

[Middlemarch]

I've opened a recordset and using .Find next, Previous, First.
Once the Find is applied the recordset appears to be limited to just what it finds.


Is this correct, if yes, is there a method to restore the original (full) recordset ?

[orange]

See this link re using a Move method after a Find method.

[CJ_London]

No code provided so just a guess you are applying a filter not using find

[Middlemarch]

Thanks for the replies, I think now my assumption .Find changed the recordset size was wrong.
But one puzzle remains, how to code Find to find either a string or a number. I've done this.. is it ok or a better method exists?

 qu = IIf((r(O).Type = 12) Or (r(O).Type = 10), Chr$(34), "")
 r.FindNext (Me!subTracks.Form.ActiveControl.ControlSource & " = " & qu & r(O) & qu)
 If r.NoMatch = True...