INSERT INTO statement syntax

[handlebarry]

Hi, the below statment seems to works but could someone please check the syntax - thanks

DoCmd.RunSQL "INSERT INTO tblContractsToProperties (GIS_Property_code, Property_Address, ContractCode) SELECT tblProperties.GIS_Property_Code, tblProperties.Property_Address, tblContracts.ContractCode FROM tblproperties, tblContracts WHERE tblproperties.check = True AND tblContracts.ContractCode = [Forms]![frmContractDetails]![ContractCode]"

 

[JerryKlmns]

DoCmd.RunSQL "INSERT INTO tblContractsToProperties (GIS_Property_code, Property_Address, ContractCode) SELECT tblProperties.GIS_Property_Code, tblProperties.Property_Address, tblContracts.ContractCode FROM tblproperties, tblContracts WHERE tblproperties.check = True AND tblContracts.ContractCode = " & Forms!frmContractDetails!ContractCode.Text

or

CurrentProject.Connection.Execute "INSERT INTO tblContractsToProperties (GIS_Property_code, Property_Address, ContractCode) SELECT tblProperties.GIS_Property_Code, tblProperties.Property_Address, tblContracts.ContractCode FROM tblproperties, tblContracts WHERE tblproperties.check = True AND tblContracts.ContractCode = " & Forms!frmContractDetails!ContractCode.Text ,adcmdText, adExecuteNoRecords

 

[handlebarry]

thanks jerry

any preferences over the two options?

 

[JerryKlmns]

Always bulk transactions with no returning records for action queries is faster, so it 's the 2nd