IMO, don't ever use the full table or a FILTERed table in a grid. Use a View to populate it, so you want to do a requery on a parameterized view.
>Hi all,
>
>i try to see result at mygrid , but it is very slow operation,
>
>f1=national number
>f4=my file number as 00123/234
>
>at my grid i must see all records have the same file number
>
>USE x2
>INDEX on f4 TO kk
>LOCATE fOR f1=ALLTRIM(thisform.text1.value)
>IF FOUND()
>
>thisform.text2.value=f4
>SELECT f1,f2,f3,f5,f6 FROM x2 WHERE f4=(thisform.text2.value);
>order BY f5;
>into CURSOR mycur
>COUNT TO s
>thisform.grid1.RecordSource="mycur"
>
>ELSE
>MESSAGEBOX("not found")
>ENDIF
>
>
>thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer