>Ernest,
>
>If you use a view you can avoid reconstructing the grid.
>
>You can also play the trick of setting grid.RecordSource = "", re-select, restore grid.RecordSource. But I prefer to use a view instead, I think it's cleaner.
>
>>David this worked out perfectly. Not only the form releases instantly but populating the 16000 records was reduced as well from about 20 to 1 second. The only down side was having to rebuild the grid after each query (well worth the extra coding). Thanks again.
Thanks.
Ernest