Maximum number of data that combo box can sort

[Anthony Joseph]

I am using a combo box to ensure that during invoice preparation the right
PRODUCT ID is selected. The product ID is quite descriptive and its a text
field. At a time 25 enteries are displayed. However the lookup database is
currently having 1000 entries and once the database is populated it will have
over 10000 enteries. This is a multiple user database split to frontend and
backend on Access 2003 running on a 100Mbps LAN. Till now all the users are
really happy and I intend implementing a dedicated server to run the backend.
Do you think I am expecting too much from Access and will my database fall
flat on my face

 

[Douglas J. Steele]

It's not so much that you're expecting too much from Access, but that you're
expecting your users to wade through far too many rows in the combo box.

You might want to read what Allen Browne has at
http://www.allenbrowne.com/ser-32.html

 

[Anthony Joseph]

Thanks a lot. I will implement Allen Browne design in my combo box later.
Thanks once again for answering the post.