Using a multi-value checklist for multiple different fields

[cmray58]

I like the functionality of the multi-value combo box (dropdown menu where you click as many options as needed), but I want each of those options to record into separate fields instead of concatenated into one field. I need to create iif statements in a query that would utilize this multi-value list. I'm thinking it's easier to use an iif statement using multiple different fields instead of pointing to specific options within a multi-valued field.

Open to other ways to do this.

[June7]

Multiple similar name fields holding the same type of data (e.g. Year1, Year2, Year3, etc) is non-normalized design and will likely cause more headaches in search operations as well as statistical analysis. Saving each value to its own record in a dependent table is the normalized approach. This requires code looping through the selected items and creating record. Or use a combobox in subform.