SQL Problem

[DS]

I think, rather I now this SQL statement's Syntax is wrong,
because I keep getting a message stating so,
any help correcting it I would appreciate.
Thanks
DS



NEWHOUSESQL = "INSERT INTO tblHouseCheck " & _
"SELECT* " & _
"FROM tblChecks " & _
"WHERE tblChecks.CheckID = Forms!frmCheckPayment!TxtSalesID & " & _
"And tblChecks.ChkHouse = -1 ;"

 

[David F Cox]

SELECT *