how to filter combobox value based on another combobox

Hi
I want to creat a form with two combobox:
The first contains only unique country from column A
The second contains only the customers with relates to the country selected.
Thanks a lot

Give the attached a go.
Although this selects floors and rooms in a hotel the principal is the same.
first combobox fills with filtered floors which on selection only loads second combobox with rooms on that floor.
Selection then loads listbox, then you can expand further.

How about

Please Login or Register  to view this content.

The line in red must go at the very top of the module, before any code.

Originally Posted by ORONHAVU1

... to filter combobox value based on another combobox ...

With a dictionary the code is very short and concise, but you can also do it without a dictionary ...

Please Login or Register  to view this content.

Thank you very much

Thank you very much

Thank you very much

You're welcome & thanks for the feedback