Form- Combo Box Linked to Table

[Jonbob]

I have a form with a combo box linked to a table which contains 100,000 rows. When I pull up the list, it cuts off at record #65,536.

Is there a workaround to this?

Thanks,
jonbob

 

[Norie]

Is the data that you want in the combobox unique?

If not then you could use a query to group it.

 

[Jonbob]

yes- the list is already unique

 

[Norie]

So you have >100,000 values in the field that populates the combobox?

 

[Jonbob]

yes

 

[SydneyGeek]

Not sure, but that sounds suspiciously like a row limit to me.
You could try having another Combo above that, with letters A to Z, that filters on the first letter of your main combo. That way, you can accommodate the full list -- and it should run a bit faster too.

Denis