Search in combo box

A

Abdul Shakeel

In a form I have a combo box listed seven thousand of inventory item in
ascending order, sometimes it becomes very difficult to reach on a specific
inventory item, typing the name of the inventory item is also not so use full
as the name of the inventory having almost same character for example:
C1 UM UDR 1 1/0
C1 UM UDR 1 1/1
and so on, so I want to search item on combo box by typing less is there any
way to do this.
 
A

Arvin Meyer [MVP]

If there is significant commonality in the inventory items, you could use
the Left, Mid, and Right functions to build multiple combo boxes and drill
down to your final record. In the example below, you could save as many as 4
characters. I'm not sure that the effort required is worth the result.
 
K

Klatuu

In addition to Arvin's suggestion, you may consider using Cascading Combos if
the items have a category or grouping you can use to reduce the search.
 
K

KARL DEWEY

Checkout the combo Auto Expand property. It scrolls to the value or part of
the value as you type in the combo.
 

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

Recreating a value in two different tables 0
combo box 1
Combo Box Requery 3
Search box for text 3
default to first item in combo box list 4
Search combo box 2
Combo Box 2
Access 2003 Filter before displaying table 2

Top