>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?
MartinaJ