Multi Select Combo Box

[John C.]

Ugggghhhhh. Can't determine how to set a combo box to
allow multi-item selection.

Thankyou.

 

[Dirk Goldgar]

Ugggghhhhh. Can't determine how to set a combo box to
allow multi-item selection.

Thankyou.

Uh, combo boxes don't allow multi-item selection; only list boxes do
(and even then you can't store the multiple selections in a single bound
field, because that would violate the rule of field "atomicity"). What
are you trying to do?

 

[John C.]

Allow the user to select multiple items to show completion
of specified task concerning selected sample points.

 

[Rick Brandt]

Allow the user to select multiple items to show completion
of specified task concerning selected sample points.

Tasks should then be a separate table that you manipulate with a subform.
One should (almost) never store multiple values in a single field.

 

[Dirk Goldgar]

Allow the user to select multiple items to show completion
of specified task concerning selected sample points.

I agree with Rick Brandt, insofar as I understand your description.
This is information that should be stored in a related table and
displayed in a subform. You could conceivably use code behind a single,
unbound combo box on the main form to add an entry to the related table
(and requery the subform) every time a selection is made in the combo
box, but that's a matter of user-interface design, not data structure.