Hi, Steven.

>One problem is navigation on my display form. If I don't pull the whole set how do I go to the next record or previous record? Although I may have this resolved. I am pulling five records plus/minus in my spt. this seems to take no more time that pulling one record and I have what I need I think.

I don't think that a previous-next navigation makes much sense over a 67K records table (indeed, I don't like this kind of navigation in any circumstance, but this could be something of a personal taste).

Anyway, you always can workaround this. Instead of pulling all the records and move with skip +/- 1, just select the next record following the one you need, like:

select * from Customers ;
 where CustName > lcCurrentCustomerName ;
 order by CustName ;
 top 1

Of course you have to make it a bit smarter to avoid duplicated descriptions, etc, but I think you have the general idea.

Another approach (the one I prefer) is to ask for some filter criteria before getting the records, and I wouldn't let the user select "EVERYTHING" under any circumstance.

Hope this helps,