Combo Box problem

[Rick West]

My database has been working for 3 years, no problems until now. FE/BE database. About .75G for the BE data, which we compact nightly.



368k records in the BE table the combo box searches (Limit to List set to No) and it has slowed to a crawl when the user tries to enter data, especially if the value has an alpha character - which is about all the time.

Have we exceeded the look-up capability of the combo box?

[pbaldy]

One solution:

http://allenbrowne.com/ser-32.html

[RuralGuy]

To add to Paul's response, I believe there is a 64K record limit to the RowSource of a ComboBox.

[Rick West]

Thanks Guys, I had already run across that bit of info. during my research but was thinking maybe there was something I was missing. Guess not.

Thanks.