Hi ,
Define View ?
I never know that there's a Define View command before. Usually I use "Create SQL View", and still adding macro sub for ORDER BY clause didn't do annything after REQUERY(), but what Mark said about indexing is really a brilliant and might be the only idea.

Thanks'