I have 15 combo boxes each with another combo box that is filtered based on what you slect in the first combo box.
but they do not work consistently. the work in terms of the data, but sometimes the selection made by the user then dissapears when they move onto the next pair of boxes, or sometimes there is nothing to select within the box, i.e. the combo box is blank and then clicking on it again data will appear!
anyone heard of these little "features"!
I attach the code for the event procedure if that helps.
ta
John
but they do not work consistently. the work in terms of the data, but sometimes the selection made by the user then dissapears when they move onto the next pair of boxes, or sometimes there is nothing to select within the box, i.e. the combo box is blank and then clicking on it again data will appear!
anyone heard of these little "features"!
I attach the code for the event procedure if that helps.
ta
John