I am using ADO to open a database, create a recordset and fill in a datagrid. I have also programmed to allow the user to re-sort the datagrid based on the column selected, which all works fine.

The problem I am having is that I am using the recordset bookmark property to keep track of my position in the datagrid but the bookmark property does not seem to update based on the latest sort. i.e. if record number 100 now becomes record number 1 due to the new sort, the bookmark still says I am on record number 100, not record number 1.

Can I force the bookmark to update itself? Is there a better way to tell what the record position is after a sort?