Search in combo box

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.

--
Regards

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Abdul Shakeel" wrote in message
...
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.

--
Regards

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.
--
Dave Hargis, Microsoft Access MVP


"Abdul Shakeel" wrote:

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.

--
Regards

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

--
Build a little, test a little.


"Abdul Shakeel" wrote:

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.

--
Regards