bluedreams

How to select by attributes by using 2 comboboxes? (VBA)

Discussion created by bluedreams on Nov 18, 2013
Latest reply on Nov 18, 2013 by rfairhur24
Hi Experts,
I am trying to create query userform by using comboboxes and a button.
I would like to choose attributes from joined table by using comboboxes.
Aim of the study is select objects which have values between first and second combobox values.
comboboxes should populated by attributes.
After selecting first value in combobox, second combobox value should be populated remaining values.
For Example:
I want to select objects by Total Points attributes. (eg: starts from 0 to 100)
Eg. in first combobox we choose 23, then second combobox should populate itself from 23 to 100.
So if we choose 23 and 51, objects should be selected which have total points between 23 and 51 (23,24,25 ...... 50,51)
To sum up i want to create query such as select by attributes:
[Total] < 23 And [Total] > 51

Thanks for your helps.

Outcomes