>>If you use NoDataOnLoad your form will instantiate very quickly. Then run the query.
>
>Doing that, but the problem is that there is a parameter passed to the form which then is used in the view filter to limit the records. Unfortunately the limited set in this case is still 93,000 large. I think I may have to do something like Doug suggested to basically only pull the records I really need. I've just been used to having the entire view available when the form opens and will have to figure out some logical issues around that.
>
>Renoir

Renoir,

On the surface, it sounds to me that you really need two views. One view that has just the required fields to support a listing of the records (for user selection), and another that retrieves the entire record via a primary key.

Enjoy ...

Doug