I have a bunch (30) comboboxes on a form. Each one has the same set of values in it. Each one corresponds to a user 'goal'. The user is supposed to select their top 4 goals. The rows in the comboxbox are 1 most important goal 2 2nd most important goal, etc.

Obviously they can't select, for example, a goal as 2nd most important, more than once. So I have a 2 column array. with 4 rows, the first column is the goal number, the 2nd column is logical - true if they 'used' the goal, false if they didn't. I am attempting to set the logical indicator for whether the goal is used in the interactive change event.

The problem is that if the goal is already used then I need to reset the listindex property to what it was before the interactive change method changed it - preventing the user from 'using it again'. The only way I can think of to do this is store the new listindex to a new custom property of the combobox, after it is determined that it can be successfully changed. If it is determined that it has been used already, then the listindex needs to be changed back to the value that is stored in the custom property. I haven't tried this yet. I hope it works.

There must be an easier way to do this. I must be missing something here. In short, how can I get the original listindex value, before it gets changed by the interactive change event.

TIA