I have a subform that displays table records as a continuous form. I am trying to position the subform to a given record. My code follows:

Set rs = frm.RecordsetClone
rs.Find strWhere ... Find does not search the entire Recordset
' rs.Filter = strWhere ... Filter works but is extremely slow
If Not rs.EOF Then
frm.Bookmark = rs.Bookmark

It appears that SQL only returns a certain amount of records, once you page forward, the rest appears. What is the best way to handle this?
(Access Project 'adp' SQL Server 2000)