Fastest way to load 1600 items into combobox

[Former Member]

Hi,

I need to load aprox. 1600 items into a new combobox on the item master form from a user defined table.

With a regular recordset (adding each record found record to the combo's valid values list) it takes forever.

Is there another way ??

Thanks...

[AlexGrebennikov · Accepted solution]

Hi!

i suppose there are no good solutions. All of them will be too slow.

I'm sure that nobody will help u.

The only solution is to redesign business-logic and create more appropriate implementation. For example, it would be a ChooseFromList-solution.

sorry for such depressing news. 😕