Sounds like a lot of overhead for something that should be very simple.
>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?