Filters are a horrible idea for a grid. The scroll thumb for the grid doesn't behave properly, which confuses the user. Better solution, do a SQL query for what you want and populate the grid with the resulting cursor.
>I have a problem with a grid on a form. I set a filter on a file to exclude "closed" reservations from the
>display. I then allow entry of a unit number, find the first record for the unit number and refresh the display
>of the grid.
>
>When it initially pulls up the grid and enter a unit. It comes up quickly. But, every time I call the grid form up
>after this, it displays the info, you enter the unit, and it takes a very long time to go to that record and redisplay.
>
>I can exit the program, re=enter and the first time is very fast. Subsequent times are very slow. I am doing this on
>a 3 computer pier to pier network. Its always fast on the one acting as the "server".
>
>I removed the filter and it ran fast in all instances. Can setting a filter on a file (15000 records and I only 300 meet the
>filter requirements) make it take, literally, minutes to pull up the data?
>
>Any help would be greatly appreciated.
>
>Brad
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer