Using SQL within VBA (based on combos)

Hi,

See attached.
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.
GenerateLetters.accdb
Patrick O'DeaAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
0
 
Patrick O'DeaAuthor Commented:
Thanks , just perfect!
0
All Courses

From novice to tech pro — start learning today.