> i have a grid in my form where i want to order the recordsource
> (a cursor from select * drs into cursor csrdrs) when my user click
> on each column's header.
>
> i want to know first in what oder is the column set, so i should be
> able to do an order by ascending or descending.

If your RecordSource is a View or temp SQL result, you can use temporary indexing:

Select (yourGrid.RecordSource)
Index On fieldX Tag tagY

and then Set Order To && Descending at runtime


hth
-Stefan