Combo boxes are slow when each combo box and subform requeries.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a faster way to filter a large table? My problem is I want to
filter a table that has over 30,000 records (rows) and 130 fields (columns).
I want to filter or use combo boxes over a dozen fileds (columns).

Combo boxes appear to be much like the autofilter or dropdowns in an Excel
spreadsheet.

I
 
As you found, loading tens of thousands of rows into a combo is very
inefficient. You might want to redesign the app another way so it is not
constantly loading all that data.

One approach is to delay-load the combo, i.e. don't load it until the user
has typed 3 or 4 keystrokes, so that there are only a few hundred matches to
load. Details in:
Combos with Tens of Thousands of Records
at:
http://allenbrowne.com/ser-32.html
 
Back
Top