Hello,
I am kind of stuck on something. I want to be able to
select more than one item off of the combo box and also
allow me to enter in a data that's not in the combo set as
well. Please let me know if you know a way of doing this,
thank you.
You can't select more than one item off a combo box (not that way in
any case).
Where do you want the selections stored? If you are trying to store
multiple values in one field... DON'T! You would be much better off
redesigning your table structure so that you have a one to many
relationship between two tables; rather than storing multiple values
in one field, you'ld store multiple *records* in the related table. A
Subform (with your combo box on it!) will let you make as many
selections, one at a time, from the combo as needed.
You can also set the Limit to List property of a combo box to No; this
will let you type in a value that doesn't exist in the combo's
rowsource and add it to the table. It won't be available next time
though. If you want to be able to add a new value to the combo list,
you'll need to set Limit to List to TRUE and put some VBA code in the
combo's Not In List event.
