Select into a seperate cursor which could use your original approach.
>I would like to apply a DynamicBackColor to a grid with ordering abilities. How would I do this?
>
>The simple approach is as follows:
>
>
>.DYNAMICBACKCOLOR = "IIF(MOD(RECNO(), 2) = 0, RGB(225,225,225), RGB(0,255,64))"
>
>
>
>I would like to get the same results based on the index that is currently in use. If I click on a header that has the ability to order the results, I would like to still see the alternating colors rather than 3 of this color and 2 of that color. RECNO() does not work in this case because they will be all jumbled based on the "SET ORDER" of the table.
>
>
>.DYNAMICBACKCOLOR = "IIF(MOD(TAG???(RECNO()), 2) = 0, RGB(225,225,225), RGB(0,255,64))"
>
>
>
>Does anyone have any ideas?
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'