>>You might want to try to catch the bottom record too, to stop that wait when the user does a pgdn or downarrow past the last filtered record.
>
>I think I like the idea of avoiding the filter. :)
>
>I was doing some performance tests today. I prefer to change the RecordSourceType to 4 and change my select instead. The filter gives unpredictable results. Doing a SQL per request seems to be a better approach.
Overall, I agree that SQL is a better solution. How are you going to cope with the delay if you have a large result-set (mentioned earlier in the thread with Ed Pikman)?