>Hello Edward! How are you?
>
>Maybe you can help me?
>
>I have a grid, and in dynamicbackcolor i have the follow code IIF(MOD(RECNO(),2)=1,RGB(255,255,255),RGB(192,220,192)), but in the header of any columns i change the order of my table, by sample:
>
>thisform.grid.column1.header.click=set order to tag cust_id
>thisform.refresh
>
>thisform.grid.column2.header.click=set order to tag name
>thisform.refresh
>
>The problem is, when i change the order of my table the grid did stay disordered
>
>
>Thanks
>Anderson Reis Girardi
Firstly, your code can be improved a little bit:
*** Header.Click
Select Table1 && assuming that this is recordsource
Set order to tag name
This.parent.parent.refresh
Then I want to ask you a question: what is the purpose of using recno() for coloring the grid? What exactly you want to indicate by this?
Edward Pikman
Independent Consultant