I have a table that has 100K records and growing fast. I place the the records in a recordset and display it in a form.

Right now, it takes a few seconds before the form is displayed when called. I forsee that going forward, it will take a longer time to get the recordset and dump it into my form. I also see memory constraints on the user's PC.

(1) Is there a way I could read, let's say, 500 records at a time in my recordset? Just like paging it?

(2) Is there a way I could check how much memory my program is eating or how efficient it is?

Thank you.