Can I select multiple records with a combo box?

[Andy]

Hi

I have three combo boxes on my form. The 1st displays the
category, the 2nd displays the work operations that
relate to each category and then 3rd displays the
materials that relate to each work operation.

In the 3rd combo box there can be up to 10 items that I
need to select. Is there anything I can do to select them
all at once to display them on my form. This will save me
doing the same operation over and over.

Any help appreciated.

Thanks in anticipation.

Andy

 

[Van T. Dinh]

In ComboBox, you can only select 1 "row".

Use a ListBox with MultiSelect instead. However, the coding is slightly
more complex as the Value of the ListBox is *always* Null. For an idea how
to use the MultiSelect ListBox, see The Access Web article:

http://www.mvps.org/access/forms/frm0007.htm