SQL and check boxes

[KentMorand]

This is no doubt an easy one. I'm trying to set a list box's row source to what I'm returning from an SQL statement. The where criteria is a check box. What I'm wondering is what do I put into the SQL statement to see if that field has a check. What I have is this

strSQL = "Select Distinct(TechName) From tblTech where tblTech.PIP1 = '" & yes & "'"

This returns a data mismatch when it comes to this line of code

Set rsRecord = db.OpenRecordset(SQL)

Is yes the value I should be passing into this SQL statement? I've tried numerous variations of quotation marks around the yes value but with no luck. Any help would be greatly appreciated and I thank everyone in advance.

 

[TPetersonFlorida]

Checkboxes return either a True or False so if the checkbox is checked then the value is True otherwise it is False.

so your string would look like this:

strSQL = "Select Distinct(TechName) From tblTech where tblTech.PIP1 = TRUE"

 

[KentMorand]

That was it... God I feel like an idiot... lol