Drop down list display options.

[chip0105]

I have a subform that uses a dropdown list to select up to six different
items. One (or more) of these items is already selected for the given
record. Is there a way to remove the previously selected item(s) from the
available list so no duplicates can be entered?

Example:

Drop Down List:
Mining
Construction
Industrial
Powergen
Defense
Marine


If Mining is selected and another item will be selected as well, Mining will
no longer be listed as one of the available items to select within the drop
down list.

Is this at all possible???

Thank you for taking the time and effort to assist an ignorant database
programmer.


Chuck
email: (e-mail address removed)

 

[New Guy]

Open the form in Design View and go to the Properties dialog box; change the
Multi Select field to Extended. This will allow you the ability to select
multiple records by holding down the Ctrl key as you select the second or
third options. However, some advanced coding will be needed from this point
to dislpay whatever you are after. Search the site for Multi Select List
Boxes for ideas on How To.

 

[Dale Fye]

I'm with New Guy on this one. I would recommend a listbox rather than a
drop-down combo box.

To provide more feedback we really need to know something about your data
structure. How (what table) are you storing the information in that relates
to the current record and the selections you have made from your combo box?
It sounds like it is bound to a field in the forms record source. But if you
want to be able to select multiple values, this will not work.

HTH
Dale