I'm trying to execute this simple SQL statement and I get this error

Compile Error
Expected: Line Number or Label or statement or end of statement

Here is the sql statement I'm using

Dim strSQL As String

strSQL = "Select * From tblCompany"
"Where cCompName Like '" & cmbCmpName.Text & "'"

DatComp.RecordSource = strSQL
DatComp.Refresh

Not sure if I'm supposed to use the like or not. I left my SQL book at home and I don't work with it every day. So if some can help me out I would appreciate it.

Thank You
Ken Devorak