You said

"when I try again I have nothing "0"in the field(flag)…….why if you can help"

so you are clicking on a grid and you want to show in the grid only the records that have the same NAM. is that right?

then you replace a column named flag with 1 for all the row that have NAM equal the NAM of teh row you clicked on. right?

then you lose the 1 and the flag become 0, is that right? if this assumption in right, do you know if you have a table buffer set. if you have a table buffer set then you need to do tableupdate().

Mo


>Thank you
>
>I have this proplem if you can help
>
>I have a grid, I get data from table(trans1) into grid1
>On click(in a grid) I write this code
>select 2
>use trans1
>locate for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>if found()
>set filter to upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>replace flag with 1 for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>endif
>
>
>sometimes it works and I have "1" in the field(flag)
>
>when I try again I have nothing "0"in the field(flag)…….why if you can help
>
>
>
>Remark:-
>
>On AfterRowcolChange(in a grid) I write this code
>
>thisform.text1.value=price
>
>thisform.text2.value=nam1
>
>thisform.text5.value=nam2
>
>thisform.text3.value=nam3
>
>thisform.text7.value=no
>
>thisform.text10.value=sale
>
>
>
>thisform.text3.value=thisform.text4.value
>
>
>
>with thisform.Grid1
>
> .Recordsource = .Recordsource
>
>endwith
>
>
>
>thisform.grid1.refresh
>
>