I have multiple list boxes which analyse different aspects of the same field. I can only make selections on one of these boxes at a time, if I make a selection in one list box and then a selection in another it clears out the first selection.
I'm bumping this old thread because I have the exact same question.
I've been using a workaround for years, which is to create separate fields for each list box, and then synchronize with the master field using macros. I consider this a horrible solution. I would like a better solution.
The attached example is from one of my live applications. In this case, users are selecting fields for a dynamic chart, but that's not the important part here. The important part here is that I want to be able to categorize these fields to make them easier for the user to locate. I also support multiple ways of categorizing the fields, each with its own set of list boxes associated with it. One tab demonstrates the problem, and the other the macro solution. The data model, triggers and macros to keep all these list boxes in sync with the master list are annoyingly complicated. There must be a better way.
