Creating Dependent Searchable Lists (List Box Dependent on Combo Box)

Brass Contributor

Hi All,

 

I am not entirely sure how I should go about accomplishing this because I believe there are a few ways to do this. 

 

I have a list of data similar to below:

 

0582    051

0582    954

0582    725

1275    654

1275    777

5290    936

5290    003

5290    051

5290    923

5290    000

 

Basically, I want to create dependent list boxes, combo boxes, or drop down lists. I feel as though combo boxes would be the best because the first box is going to be populated with over a thousand codes (first column) so it would be best if the codes were searchable. Depending on the choice selected in the first box, only 20 or less options will appear as choices in the second box. However, the second box needs to allow for multiple selections. A list box would probably be the best option for this. How could I create a list box dependent on a combo based on the setup of the data above?

 

In addition, would the second box populate another cell with its data? For example, all of the codes that are selected in the second box should appear in the cell next to it. 

 

If there is any more information I can provide, please let me know.

 

Any help is appreciated!

 

Thanks,

Anthony Smith

 

0 Replies