This is exactly waht I wanted to add too. Don't use filters and grids together. Use either local view or select SQL.
João,
>Beware using filters in a grid. If you have a thousand records you might be ok. If you have many records it will be so slow as to be unusable. We found this out the hard way. When a customer first installed our program it worked great. Three years, and the addition of many thousand records later, it took 30 seconds for the form to load with the filter on. With the filter off it loaded instantly. If you expect to have a large number of records I suggest you have the user enter the criteria for a subset such as a date or invoice number range and run a SQL to put the recs in a cursor for the grid.
>John.
>
>>Hi Tore,
>>
>>Thank's, so simple and i can't remember that.
>>
>>Have a nice weekend.
>>
>>João Batista
If it's not broken, fix it until it is.
My Blog