Absolutely no shadow of a doubt - use the SQL. The RDBMS is tuned to search for item data in a set based way (SELECT...WHERE...) The recordset method returns a lot of extraneous data that you never use. If you want to scroll the last few records then just return the last few records using a WHERE clause. (This is what a filter does anyway) but NEVER NEVER NEVER return the whole recordset and use MoveLast.
Cheers,
P.




Reply With Quote