>>>Hi
>>>
>>>I have a form with a grid which has a RecordSourced to a local table/DBF. I have an input field which I want to allow a user to enter some text in and then use that text to SET FILTER on the table for a field containing that entered text.
>>>
>>>The form loads and the entire table contents is displayed in the grid. I enter some text in the field and click a button which applies a SET FILTER TO instruction. The table is refreshed and correctly displays the filtered data. This is so far OK.
>>>
>>>But when I now click on the table, for example in the vertical scroll bar, some strange things happen; (1) a small VFP window appears saying "Filter cleared" and then (2) the entire form re-loads! Indeed, every time I repeat this process it reloads another copy of the form as soon as I click anywhere on the grid.
>>>
>>>The grid parent itself has no code associated with it. The contained columns, which have text controls, have DBLClick and InteractiveChange method code. But this happens even when I only click in the grid's scrollbar.
>>>
>>>Anyone can suggest what I am doing wrong here?
>>
>>Hi Jos,
>>
>>What is filter expression?
>
>SET FILTER TO ATC( m.Search_Text , DATABASE.FIELD1 + DATABASE.FIELD2 ) > 0

Search_Text is going out of scope?