Stefan,

PMFJI, have you tried this ? Even after a REQUERY() on the view? There is a lot of tricky stuff involved here.

For what I remember the "sort grid", download#9970 from Vlad Grynchyshyn will be a good example on how to do sorting on the grid with header click. I'm not sure if some small problems with views in that example are fixed. If you have problems with views on that, feel free to post to me.

Further discussions of the issue will be in thread#622396

Agnes

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