Form to lookup/search for data

[sirace]

Ok, here's my dilemma. I have a database with 350000 transactions. Each transaction is linked to an account number. There about 64000 unique account numbers (field: account_no). How can I make a lookup box that will only include unique account numbers. Currently, I have the look up box get the values from a query that uses "group by" to generate a list of unique account numbers, my problem is that every time I open the form it runs the query and then it runs it again when I click on the lookup box. Any suggestions on ways to speed this up? On my computer it takes about 45-60 secs to run the query.

 

[SteveR77]

Turn the query that does the lookup into a Make Table query. Then use the table of unique values to populate the list box. This will eliminate the processing time for the query.

I hope this helps,

Steve

 

[sirace]

Thanks!