Record Navigation Control Bug

I developed a data access page that incorporates a microsoft office record
navigation control. The data source for the data access page is an SQL query
that returns several hundred rows. If I sort/filter/sort the query results
using the record navigation buttons, the filtered and resorted recordset
includes only a subset of the recordset returned by the query. This problem
occurs only after sort/filter/sort and not after the first sort or the filter
events. Upon further investigation, I was able to determine that the records
contained in the sort/filter/sort recordset were based on the top 100 (A-Z
sort) or bottom 100 records (Z-A sort) returned by the SQL query (anything in
the middle gets ignored). Any thoughts on root cause and fix or alternative
solution based on third party ActiveX control would be greatly appreciated.
$ bonus for first correct solution. Thanks.