Grid behaviour

[raymanw]

Hi all,

I have a strange problem that needs your help.

I set the grid's ROWSOURCE to the transactions table & the COLUMNFIELDS to the fields of the table with some iif() calculations.
I setfilter on the transactions table when the values of 2 combobox changes.
I created multiple textboxes with FIELD set to the transactions table field and a procedure to update their values when the grid comes into focus or when changing the record focus in the grid.

Here's the problem:
If I use the REFRESH method of the grid, the record displayed in the grid is always the resulted record of the first setfilter. The textboxes values reflected the same when I click on the grid.
If I don't use the REFRESH method, the grid doesn't display any record but when I click on the grid, the textboxes reflect the values of the correct record.

Thanks.

[raymanw]

Hi,

The behavour, I think, is related to setfilter. The first record in the table always appear in the grid on the second & subsequent setfilter commands.

Can setfilter not be used in this manner? ie. To dynamically filter the data based on user's input?

Thanks.