This is a simplified version of my requirement.
I have a table with thousands of records and wish to "count" the records that match the criteria chosen by the combos. E.g. choose "Gender=M" and "Personality=NICE". How many people match these criteria?
This is best explained by looking at the attached.
What I Need: When the user clicks "Count The Chosen" the system should display a msgbox that show how many records met the criteria.