You may write your program with loops, if you treat the CheckBoxes as elements in an array. See FAQ #8110, for ideas on doing this.

>Hi everyone:
>
>I currently have a combo box that is populated by rowsourcetype=3 with a row source sql statement taking values from a table and into a cursor. There are so many different values in the combo box that I want to give the users a chance to minimize the number of entries in the combo box that they are searching for.
>
>What I've done is added check boxes below the combo box, and in the click event on one of the check boxes it changes (in effect filtering) the values that are populating the combo box so that the combo box will only include the values that correspond to the value in the check box. However, to do this for each check box to filter the values even more is extremely tedious and will require hours of work (I would have to write if statements for each check box to check for the values of each other check box before populating the combo box). I am not a great programmer so maybe I am missing something that is an obvious way of dealing with this. What I want is, when the person checks each additional check box, the items in the combo box are filtered to include the most recently checked items as well as all other items that are currently checked.
>
>Maybe there is an easier way. Any advice would be greatly appreciated, and if any clarification is needed, please feel free to ask. Thanks for your help.
>
>Paul