Cascading combo boxes

[dand_dd]

I want to filter a list into a form. I have multiple combo boxes. Each combo depend of the other combobox.

How to make something like this?

[dand_dd]

I want to make a form with multiple combobox for filter of the entire table.
Possible combinations:
F1-->F2 --> F5
F1-->F5 --> F2
F2-->F1 --> F5
F2--> F5 --> F1
F5--> F1 --> F2
F5--> F2 --> F1

Must function like in Excel file example.

When I choose one value from F1 then for F2 I have all values minus values where F2 has not a correspondent in F1 and identical for F5

Thanks

[dand_dd]

I have made something. But it is not working. Can someone help me to correct what i had written in VBA code?

[orange]

I want to filter a list into a form. I have multiple combo boxes. Each combo depend of the other combobox.

How to make something like this?

See this site:
http://www.btabdevelopment.com/main/AccessSamples/tabid/54/Default.aspx