Combo box two columns

[Lasse T]

Hello !!

I hope someone can tell me if this is possible.
I have a combo box showing two columns. Column one is item number (record
source) and column 2 is item description. Now the user needs to know at
least a few of the first numbers in the item number to have any use of the
combo box. I would like to let the user choose if he wants to write item
number or item description into the combo. This would help a lot sins the
user always knows the description but not always the item number.
Is this even possible?

Thanks in advance
Lasse T
-----------------

 

[Jeff Boyce]

If the user always knows the description, why make them learn item numbers?

Your combo box can "hide" the item number and display the description,
letting the user pick from description. To do this, you would have item
number and description as 1st and 2nd column, then set the width of the
first column to 0.

You can do this using the properties of the combo box, or when building it
via the wizard.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Lasse T]

Ok. That works. Thank you very much.

Lasse T
----------

If the user always knows the description, why make them learn item
numbers?

Your combo box can "hide" the item number and display the description,
letting the user pick from description. To do this, you would have item
number and description as 1st and 2nd column, then set the width of the
first column to 0.

You can do this using the properties of the combo box, or when building it
via the wizard.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/