>Dear all,
>
>In my design, a grid host a table which show the range of a control field:
>
>Column1 Column2 Column3
>control field Range from Range to
>---------------------------------------------
>A 10000 19999
>B 20000 39999
>C 40000 89999
>
>I edit the grid by a commandbutton EditItem which set theGrid.readonly to .f.
>
>How can I do that when I lost focus from colum2 or column3, It compare the value of the cell with the record before and after, say if the column2 of control field is <20000, a prompt warns me to check the entry.
>
>Wit regards,
>
>Ransome
So,
Thinking this is buffered if applicable use an array. So you can check :
if this.RowId > 1 and this.Value <= thisform.arrCheck[this.RowId-1,2]
if this.RowId < MaxRows and this.Value > thisform.arrCheck[this.RowId+1,1]
thisform.arrCheck[this.RowId,1] = this.value && Or 2
Cetin