>Hello,
>I have a problem with a Grid:
>The recordsource of the grid is a table (recordsourcetype = ALIAS). With comboboxes I am able to set filters on this table. When a filter is set on the table, the grid is filled with its contents (the filtered table), which is working good so far. However, as soon as I click on the grid, the grid becomes empty.
>Does anybody know what the reason for this behavior might be?
>Thanks for help!
In general, it's not recommended to use filtered recordsource for grid. The reason is that it will be slow. You problem seems to be different. It may happen that you used some variables in filter expression and they go out of scope somewhere. Anyway, try to use more generic (non-filtered) approaches building your grids.
Edward Pikman
Independent Consultant