slow response in combobox

[ronphx]

I have a combobox to look up a customer name from the last name and first name (lname,fname). The data tables are located on a network. I have set the rowsource to the datatable TBLMASTER, which has about 56,000 records.

The combobox is ordered by lname and fname. When I start typing the last name, the response rate is extremely slow. There is nobody else on the network. I'm guessing the response will always be slow because of the size of the table, and this probably will not work.

Does anyone have any suggestions?

Thank you.

 

[Blorf]

Does it have to query live data? I am assuming you are linking to or odbc'ing to the tables. Maybe use a query to do a make table, or do an import, so the external tables are only read once.

ChaZ

 

[ronphx]

It does have to be live data since the master file changes frequently (the table is a linked table).

Another thought I had was to use an index I had on the last name, but I don't know how to display indexed records on a continuous form. Do you?

 

[formerTexan]

Hi,

I'm not sure if you are getting a slight delay or enough of one for a coffee break. But 50,000+ records is rather more than Access combos are comfortable with.

First, there are dozens of things that can be looked at to potentially improve query speed. Lots has already been written, so do a search on this forum or a search engine.

And last, perhaps 50,000 rows is simply too many. Consider redesigning the combo box to only return a recordset based on the first letter of the name. The user can either select from an alphabet list or it can be done on the fly as the user enters the name. There will be far less network traffic and the combo will have less work load.

Cheers,
Bill