>Thanks Cetin. I like the idea with array.

Dejan,
I see you need colors also. Then make the array 2 columns and put the colors n second column. Your controlsource and dynamickbackcolor would look like :

myGrid.myColumn.Controlsource = "(thisform.myArray[myTable.status_no+1,1])"
myGrid.myColumn.DynamicBackColor = "(thisform.myArray[myTable.status_no+1,2])"
Cetin