Dynamic Combo Box - Change List on Previous Selection - Or "Check All That Apply"
I have a combo box that looks up the values in a table on one of my forms. I'd like to add the combo box a few times to allow the user to make more than one selection from the list (check all that apply workaround). What's the best way to do this? Should I have the combo based on a query and use Not Like "the first selection" in the row source to populate the choices for the next combo box?
Is there a better way to do this? Ultimately I'm trying to store "check all that apply" data in a single table, with an ID and the Choice selected sharing a key. I've looked around and still haven't found a good "check all that apply" workaround. Am I missing something?
Any help would be appreciated.
David
I have a combo box that looks up the values in a table on one of my forms. I'd like to add the combo box a few times to allow the user to make more than one selection from the list (check all that apply workaround). What's the best way to do this? Should I have the combo based on a query and use Not Like "the first selection" in the row source to populate the choices for the next combo box?
Is there a better way to do this? Ultimately I'm trying to store "check all that apply" data in a single table, with an ID and the Choice selected sharing a key. I've looked around and still haven't found a good "check all that apply" workaround. Am I missing something?
Any help would be appreciated.
David
