Filter my subform by updating combo box

[HRakibul]

hello,
i have a table contains 5/6 column. now i need to filter the table on a form randomly.
suppose i have 6 different combo box for 6 column. Now on the sub form the control shows the whole table. i this case i have clicked the 3rd combo box, then it will show the whole column in its list. if i select any one of it the table will show the common values below. then i will click the second combobox which will populate the present data shown into the subform table after the first filter.

after that i wish to filter the fifth column where the fifth combobox will populate the data after the second filtering.

by all means the active data into the column will ony populate into the combobox.

 

[llkhoutx]

Edit the subfform filter or record source after each combo box update and of course, clear all filtering on some event, maybe on the parent form OnCrrent event..