hi,
thank you for reply,
but if can you can send the select statment as my small code locate and filter.
thanks,
>Hi Mohammed,
>
>Don't use SET FILTER with the grid. If your grid is for display purpose only use Select-SQL to select records into cursor. Have your grid work with other cursor which you create in form's load with CREATE CURSOR command. When you need to change filter, do Select-SQL and then zap your cursor and append from this temp cursor.
>
>>hi all,
>>i need help to get what i insert at textbox form my table,
>>
>>i try via field name mac1 from mytable as "IO2",i see at my grid every name begin with io2 as io21,io22,io27...
>>

>>    LOCATE FOR   dat=(thisform.text2.Value) .AND. table1.mac1=ALLTRIM(thisform.text18.value ) AND TYP=THISFORM.TEXT24.VALUE&&typ is numaric
>>
>>IF  FOUND()
>> set filter to  MONTH(dat)=MONTH(thisform.text2.Value) .and. mac1=alltrim(thisform.text18.value)AND TYP=THISFORM.TEXT24.VALUE
>>
>>

>>thanks.