Reusing Collected query Data?

[Ktx7ca]

HI

I have a table with over 250,000 records in it accessed by several users over the network

I'm using a find as you type listbox to view the data

When I enter "T" into the textbox it looks at the 250,000 records and brings back every thing starting with "T" when I enter "TH" It looks agian at the 250,000 records and returns with all "TH" records

What I want to do to speed things up is to use the first set of returned data that contained all the records starting with "T" which might be 40,000 records and search that for "TH" and use the "TH" data to search for "THE" and so on

any Ideas on how to do this or why I shouldn't great apreciated.

 

[RuralGuy]

How about a slightly different approach?

http://allenbrowne.com/ser-32.html

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[PHV]

Why not simply add an index to the relevant column in your table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886