Smart Filtering my subform

[HRakibul]

hi,
i have got a problem about filtering my subfom. i need a filtering system using combo box. the whole data of the table will be shown into the subform. and each combobox will populate each column of the subform table.
i have given two attachments for instance. here the first combobox pupulated the buyers column. while i will select the value then the subform will filtered accordingly. after the filtered condition i need to have the present colors shown into the subform populate to my color combobox.

if i wish i could start my from the Order or lot or color. so i need an indepedent filtering system.

and finally i need a report by anything i will have filter. :banghead::banghead::banghead:

 

[jdraw]

Tell us about your database. A 1 table database is extremely rare.

Please describe to readers in plain English what the database is about.

 

[HRakibul]

the database is very simple. it contains a table now i want to filter the next columns according to the subform shows the values for each column u can see my db attachment.

 

[BigHappyDaddy]

For the combo box issue, trying searching the term "cascading comboboxes".

 

[HRakibul]

For the combo box issue, trying searching the term "cascading comboboxes".

i know about the cascading but there is a problem with that. the comboboxes are dependent on one to another. the second one is dependent on the first one. but i need no dependencey.

i need randomly selected column, the current data shows into the subform it will also show into the combobox. i could select among them by the combobox.

 

[BigHappyDaddy]

The concept still applies. Just instead of the previous combobox, you need to select from the specified column (filtered).

If this is incorrect, please restate your original problem as I am not following otherwise.