Syntax Error Help

[aschachtel]

Anyone see the syntax error (missing operator)?

Me.cboBrickAttributeValue.RowSource = " SELECT tblBrickAttributeValue.CoreAttributeValueDescription, tblBrickAttributeValue.CoreAttributeValueCode, tblBrickAttributeValue.CoreAttributeSpecificTypeDescription FROM tblBrickAttributeValue " & _
" WHERE CoreAttributeSpecificTypeDescription= " & Nz(Me.cboBrickAttribute) & _
" ORDER BY CoreAttributeValueDescription"


supposedly the problem is in
" WHERE CoreAttributeSpecificTypeDescription= " & Nz(Me.cboBrickAttribute) & _

 

[bob fitz]

Try:
" WHERE CoreAttributeSpecificTypeDescription= '" & Nz(Me.cboBrickAttribute) & "'" & _

 

[aschachtel]

You rock! That was it, thank you! What exactly did that change about what my code was saying?

 

[bob fitz]

The code you had was fine when dealing with numeric values. When using text values you would use the code I posted. See: http://allenbrowne.com/casu-17.html