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
>
>IF FOUND()
> set filter to MONTH(dat)=MONTH(thisform.text2.Value) .and. mac1=alltrim(thisform.text18.value)AND TYP=THISFORM.TEXT24.VALUE
>
>
>thanks.
If it's not broken, fix it until it is.
My Blog