>hi,
>
>Showing data with a grid and set filters to view the wanted records is a very common thing.. i think most people should have tried it..
>
>I also have a form to do such thing, but for one of the filter settings, the grid would become VERY slow, each click on the grid takes 3-5 seconds to get focus, but it works just fine with other filters..
>
>would anyone please have a look and see if the following filter would make the grid act so strangely slow?
>
>select MyTable
>
>filter_expr=allt(thisform.myTextbox.value)
>filter_desc=iif(UsingFirstLang(), "name1", "name2")
>set filter to at(filter_expr, &filter_desc)>0
>
>thisform.grdIT03Itemlist.refresh()
>
>
>any idea? Please help~
>Jimi
Jimmy,
Filters and grids are not common :) Whenever possible do not use (personal opinion).
Instead try making Recordsource directly an SQL (needs index on name1 and name2). Then all you would do is a grid.refresh or grid.recordsource=grid.recordsource if not indexed (I don't know why but grid goes blank if not indexed).
Cetin