Combo Box Record Number Limitation

G

Guest

I have a form that uses a combo box to search on part numbers. There are more
than 85,000 part numbers (records) to search on, and these are alphanumeric
part numbers (data type is “text†in the table design). The combo box will
not list/display all part numbers.

I think I read that Access combo boxes will support up to 64,000 records or
so.

I have arranged part numbers by category. This reduces the number of part
numbers to search on, but it means you have to know what category a part is
in before opening the pulldown selector. I would like to be able to sort on
all part numbers if possible.

Suggestions?
 
F

fredg

I have a form that uses a combo box to search on part numbers. There are more
than 85,000 part numbers (records) to search on, and these are alphanumeric
part numbers (data type is ´text¡ in the table design). The combo box will
not list/display all part numbers.

I think I read that Access combo boxes will support up to 64,000 records or
so.

I have arranged part numbers by category. This reduces the number of part
numbers to search on, but it means you have to know what category a part is
in before opening the pulldown selector. I would like to be able to sort on
all part numbers if possible.

Suggestions?
Click to expand...

See:
Combos with Tens of Thousands of Records
http://allenbrowne.com/ser-32.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Basing one combo box on a query result and auto fill a second fiel 11
Link two combo boxes on a form 2
how do i link a combo box to another combo box or list or text bo. 1
Combo box 8
Forms with Combo Box 4
Hitting Enter Twice in the Find and Replace Dialogue Box 6
Display related field based on combo box 1
Using a combo box to find a record 7

Top