Speeding Up Access 2007 Text Searches

Question

I have a database for tracking customer purchases over history. One of my forms allows you to search for a customer name, and a subform displays all recent purchases.

I have a total of 474 customer records. I am tracking a total of 2119 purchase records. The BE and FE are already split, which may be slowing things down, but is needed for distribution and to help control file size.

I am simply using the search box located at the bottom of the form by default.

Is there anything I can do to speed up this search function? I would be ok with it waiting for complete input rather than searching with every character change.

Answer 1

If I understand you correctly, you wish for a way to quickly select customers by name. If this is the case, I believe the best thing for you is a combobox that finds a record on you form. The combobox wizard will do the work for you, simply add a combobox and choose "Find a record on my form" from the options offered.