SQl statement with two where conditions

[foxtrot123]

For the life of me I cannot get the correct syntax for this. The punctuation for the second where condition is incorrect. Any suggestions?

Me.cboDose.RowSource = "SELECT Label FROM tblLookup WHERE tblLookup.[Med]='" & Me.cboMed & "'" AND tblLookup.[Notes] = "Swallowed"

 

[nanscombe]

I believe you need to put single quotes around the word Swallowed and lose a double quote before AND tblLookup.

Me.cboDose.RowSource = "SELECT Label FROM tblLookup WHERE tblLookup.[Med]='" & Me.cboMed & "'[COLOR="Red"]"[/COLOR] AND tblLookup.[Notes] = "Swallowed"

becomes

Me.cboDose.RowSource = "SELECT Label FROM tblLookup WHERE tblLookup.[Med]='" & Me.cboMed & "' AND tblLookup.[Notes] = [COLOR="Red"]'Swallowed'[/COLOR]"

 

[foxtrot123]

That was it! Thank you.

 

[nanscombe]

You're welcome.

Sometimes it just requires a second pair of eyes to see things that we miss.