Limitations to creating a combo box to find records?

[Guest]

To anyone who can help...

I've create a database many years ago that has an unbound combo box to find
records using "NAME"...

Through the years I've updated the database and now am on Access 2000 & 2003.

There are over 66,000 names in my table and not all names are being
displayed in the combo box.

Are there limitations on the box to not display all names? If so, is there
a work around?

Thanks

 

[Douglas J Steele]

Yes, there's a limit (I believe it's 65,536, the total number of distinct
value that can be delimited by an Integer value.)

See whether what Allen Browne has at http://www.allenbrowne.com/ser-32.html
is of any use to you.