Can someone tell me how to retrieve records 10 at a time without numbering the records in the database (Access 2000). I want to display 10 records at a time on a form. Keep in mind that the records retrieved may not be one behind the other (ie Record1, then Record2, then Record12).

Please help.