>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.