>Basically what I want to do is find a way to sort the datagrids contents when clicking on the columnheader.
Why don't you just disconnect your recordset from the connection (set rst.ActiveConnection = Nothing). You will then be able to use the Sort method of the recordset.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com