JohnyG
09-11-2008, 12:54 AM
I am trying to build a user form which will be used for searching purpose.
I have connected 4 columns with respected Comboboxes. First of all I would only like to get unique values. For examples Column A contains three values which keep on repeating in combobox. So?
a) I need only unique values in all comboboxes.
b) Secondly I want the search functionality that should work in following manner.
If I selected any value in Combobox 1 then when I click on Combobox 2 I will get only the filtered values basis combobox1 selection. This functionality should be dynamic because I don?t want any fix format for search criteria. Means if I select any value directly in Combobox3 then all the other combobox should get filtered basis selection in Combobox 3. and this way search gets narrowed down with every combobox value selection.
I have connected 4 columns with respected Comboboxes. First of all I would only like to get unique values. For examples Column A contains three values which keep on repeating in combobox. So?
a) I need only unique values in all comboboxes.
b) Secondly I want the search functionality that should work in following manner.
If I selected any value in Combobox 1 then when I click on Combobox 2 I will get only the filtered values basis combobox1 selection. This functionality should be dynamic because I don?t want any fix format for search criteria. Means if I select any value directly in Combobox3 then all the other combobox should get filtered basis selection in Combobox 3. and this way search gets narrowed down with every combobox value selection.