I have a huge list of records for thsi client that they have grouped into categories with a category field. They want to view the list on screen but grouped by category. How do i get my code to loop through each category creating a recordset for each category ? then moving on ???

Can you elaborate on this?

You can create a SQL statement with GROUP BY command.

SELECT * FROM Tbl WHERE Condition GROUP BY Class

Then loop thru the recordset to display the records