Combo box is freezing when I interact with it.

[luppi13]

I have a MS Access 2016 application that is connected to MS SQL.
I have created a Main Menu form that allows the user to choose a loan from a combobox.


The query used to populate the unbound combobox uses a query on 2 tables (all records in table1 where there is no record in table2). There are 5 columns and the first column is the bound column.
It doesn't matter how I get into the combobox. Sometimes it works and sometimes it freezes for at least 5 minutes. Not user acceptable. PLEASE HELP!!

[Minty]

How many records are in the table? Are the joining fields indexed?
Assuming it's quite a lot of records, could you not create a view on the server to populate the combo with?

[ranman256]

yes, you probably dont want it loading thousands of records.

[luppi13]

Thank you for your response. Yes, there are about 14,000 records. However, sometimes it works just fine. It seems like when I click on the arrow and then click in the textbox of the combo box, it freezes. Not every time though.

[Minty]

14,000 Is a very long list for a combo, particularly to then be joined to another table, that is on a remote server.
Can you not restrict it to a more reasonable number with a "pre-filter" ?

How are you connecting to the network where the server sits, wirelessly?

[luppi13]

I am connected through a VPN remotely. I believe that most of the team that will be using the application will be on-site. I'll see what I can do about filtering the list even more. I'll be back! LOL

[luppi13]

It doesn't freeze while populating. It freezes when I scroll a little/lot and then place my cursor back into the box and start to type. Would the number of records still contribute to this?

[luppi13]

Ok... I filtered the data by purchase year and it don't have the freezing issue!!! Thank you SO MUCH!!

[ranman256]

what is in the list that needs 14k choices?
can you 1st give a text box, for user to enter a key word, which would filter down the list?