>>>>
>>>>Try to clear grid controlsource first and set it back on the end
>>>>
>>>>

>>>>thisform.Grid1.ControlSource = ""
>>>>IF thisform.opgSortDirection.option1.Value = 1   &&Ascending
>>>>	SELECT * ;
>>>>	FROM curBrowseModal ;
>>>>	ORDER BY cSortSeqASC ASC ;
>>>>	INTO CURSOR curBrowseModalS
>>>>ELSE
>>>>	SELECT * ;
>>>>	FROM curBrowseModal ;
>>>>	ORDER BY cSortSeqDSC DESC ;
>>>>	INTO CURSOR curBrowseModalS
>>>>ENDIF
>>>>thisform.Grid1.ControlSource = "curBrowseModalS"
>>>>thisform.Grid1.Refresh()
>>>>

>>>>
>>>>
>>>>But I prefer to create and use an index and change the order on the fly
>>>>
>>>>
>>>>Regards,
>>>>Onytoo
>>>
>>>To clear the controlsource is exactly the way NOT to do it!!!!!! Read my code to see how you avoid it.
>>
>>Yes, I already read your codes, but that is your "safe select" method, not mine.
>>If you read last line of my reply, then you should see I always use index for this purpose, so I never use "safe select" method
>>or emptying grid.controlsource on runtime.
>>
>>
>>Regards,
>>Onytoo
>
>By setting conrolsource to blank and then back to the new cursor, you lose all formatting, dynamicxx stuff, and most other settings which are tied to the columns. By using Safe Select you get the best of two worlds. And by the way, I always create the index tags I may need in the lines after I create the empty "gridmaster" cursor.


Thanks, Tore. So far I have tried your method and it works. Thanks to all.