>>The program I used to use displays many records in a grid format...ie I could type in a Mfg Name and get a list of all equipment by that Mfg.
>
>OIC. The fuzzy search is based on the finding the first record that either evaluates as matching the value input or finding the first record that evaluates as being greater than. In this case, an SQL statement, with the proper indexes, is probably going to be not only the most efficient, but the easiest to maintain as well.


I don't know if my suggestion is feasible, but I'll offer it for thought anyway. The responses will educate me as well.

If your problem is the speed with which the grid's source is refreshed every time you requery.........

would it be possible to use the entire cursor/table as a source and merely reposition the record pointer when the search criteria changes??? Granted, the user would be able to scroll records before/after your "selected" records, but that might not necessarily be a bad thing.

.........Rich