为何运行不了，提示操作符丢失

付谦

With Node
   txt当前名称 = .Text
End With
CC = DLookup("表1.条件", "表1", "表1.内容='" & txt当前名称 & "'")
MsgBox CC
strSQL = "SELECT * FROM 员工 WHERE '" & CC & "'"
       Me.员工简况.Form.RecordSource = strSQL
以上代码 MsgBox CC处能显示出我要的表达式，可运行strSQL = "SELECT * FROM 员工 WHERE '" & CC & "'"这语句总是提示操作符丢失，这句错在何处，应该怎么改，请帮助

todaynew

where  某字段=cc  或者 where 某字段 like cc

andymark

strSQL = "SELECT * FROM 员工 WHERE " & CC

or

strSQL = "SELECT * FROM 员工 WHERE " & CC & ""