Simple SQL Statement

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

[Glenn]

I'm not sure this it, but the 2 parts for your SQL statement aren't connected with a line continuation and a ampersand. ie

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

[dcarlson]

You'll also need a space between tblCompany Where such as

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

what is tblCompany and cCompName a variables?
then your sql missing more then few &
strSQL = "Select * From " & tblCompany & _
" Where " & cCompName & " Like '" & cmbCmpName.Text & "*'"
i you use Like then mayby you can use *

[YoungBuck]

Just a tip. Use debug.print when working with strings because it is easy to forget things like spaces. :P :P