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?