hello,
thank you for reply

i put the code as it is(but i get a meesgae(filter cleard) and lcValue not found
but the value found in mytable. any idea.

SELECT book1
index on no tag no

lcvalue= UPPER(ALLTRIM(THISFORM.TEXT24.VALUE))
SET FILTER TO UPPER(NO)=lcValue

LOCATE
IF EOF()
MESSAGEBOX("NOT FOUND")
*- Clear the filter.
Set Filter To
ELSE
THISFORM.GRID4.REFRESH
ENDIF
*- The following Endif looks redundant.
*--- endif
endif-------this is for if nkeycode=13