DropDown Control

[excelfustrated]

I have a list. Made of three columns. I want to be able to put thi
list in a drop down box (several different boxes) so people can mak
multiple selections from the list into a form (there are over 400 item
total)

I have tried the drop-down list. Got two things listed but when
click on it, it shows the three columns, however, when I loseFocu
however, it only shows the first column. I want people to be able t
print out their selections.

Also, I have tried the bound box thing and it seems to default to th
higest level item. (i.e. I have a list of food codes, nomenclature
and Unit of Issue - when I pick something that has the same unit o
issue as one of the higher items, it defaults the codes an
nomenclature to that item)

HELP! I'm getting really fustrated

 

[Juan Pablo González]

I have a list. Made of three columns. I want to be able to put this

list in a drop down box (several different boxes) so people can make
multiple selections from the list into a form (there are over 400
items total)

I have tried the drop-down list. Got two things listed but when I
click on it, it shows the three columns, however, when I loseFocus
however, it only shows the first column. I want people to be able to
print out their selections.

Also, I have tried the bound box thing and it seems to default to the
higest level item. (i.e. I have a list of food codes, nomenclature,
and Unit of Issue - when I pick something that has the same unit of
issue as one of the higher items, it defaults the codes and
nomenclature to that item)

HELP! I'm getting really fustrated.

You should try using a ListBox instead of a ComboBox.

 

[Tom Ogilvy]

use a multicolumn list box (rather than a combobox) with the multiselect
option.

your second problem sounds like you are using some type of lookup formula.
(not sure what the bound box thing is). If you are talking about dependent
boxes, then it would be hard to tell you how to fix it or do it based on the
limited information you have shared. Are you using methods from Debra
Dagleish's site ( http://www.contextures.com/tiptech.html )