Hi Moises,
Are you sure you want to use FILTER? Perhaps other solutions would be better.
In any case, don't use form's properties as you do, because you're looking for trouble this way.
lcValue = thisform.text1.value
lcFilter = 'field = [' + m.lcValue + ']'
set filter to &lcFilter
locate
thisform.grid1.refresh()
Still it would be better to run a select statement based on your criteria, zap the grid's cursor and insert from the temp cursor.
>Whenever I apply the filter below by a button click event,
>the filter works
>
>However, the user has to scroll up the grid so he can se all records
>that matches that creteria
>Sometimes the user forgets to scrow up, because only one item appears,
>but surely there are more items above (hidden)
>
>How can I do so more records appears on the whole grid
>
>*********************************************************
>SET FILTER TO UPPER(ALLTRIM(TEL)) = UPPER(alltrim(thisform.pageframe1.page1.text1.value))
>
>THISFORM.REFRESH
>*********************************************************
If it's not broken, fix it until it is.
My Blog