Hello, I have two list boxes on a form that are populated by two indexed tables (ID PK and then a field for the category). I had these in the form as multi-select list boxes which worked out great for the form layout and data entry, but it is causing some havoc with other parts of the DB code. My question is, what other options do I have to replace this list box function? I would like to store the results in the same way (comma separated list), but not have the 'multi-select' list box property.
Does anyone know a method to allow for data entry similar to the multi-select list box but without the compatability issues that crop up because of this type of listbox?