Hi - i tried your example but I don't think I am asking correctly. Here is the results code i am trying to use based on that drop down menu i gave before (for "name" where i have ????? i am using SBI, but I know this is wrong, I need more than one)
elseif request("validate")=1 then
strWhere="Where SBI = '%" & strSBI & "%' or SBE = '%" & strSBE & "%' Order by CompanyName"
strSQL = "SELECT Companyname FROM Vendors Where WHERE SBI = 'YES' OR SBE = 'YES' OR MBE = 'YES' OR WBE = 'YES' ORDER BY CompanyName "
Set rsCount = conn.Execute(strSQL)