Multi Select Combo Box

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

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

Thankyou.
 
John C. said:
Ugggghhhhh. Can't determine how to set a combo box to
allow multi-item selection.

Thankyou.
Click to expand...

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?
 
Allow the user to select multiple items to show completion
of specified task concerning selected sample points.
 
John C. said:
Allow the user to select multiple items to show completion
of specified task concerning selected sample points.
Click to expand...

Tasks should then be a separate table that you manipulate with a subform.
One should (almost) never store multiple values in a single field.
 
John C. said:
Allow the user to select multiple items to show completion
of specified task concerning selected sample points.
Click to expand...

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.
 
Back
Top