SQL in VB Code - update

[T Best]

I got it to work using the line continuation character but now i'm getting
and "Invalid Operation" error. That doesn't help me at all. Does anyone know
why i would get that error?

strSQL = "INSERT INTO tblSNMain ( InsuredName, TradingAs, InsuredAddress1,
InsuredAddress2, InsuredCity, InsuredState, InsuredZip, BusDesc, BrokerCode,
BrokerName, BrokerAddress1, BrokerAddress2, BrokerCity, BrokerState,
BrokerZip, InsCo, PolNumber, PolType, PolEffDt, PolExpDt, DedEachOcc,
EnhanceEndDeductible, WindDeductible, ReplacementCostValue, ActualCashValue,
GLGenAggregate, GLProdCompOpsAgg, GLPersonal_AdvInjury, GLEachOccLimit,
GLFireDamageLimit, GLMedicalExpenseLimit, Exposure, Rate, Premium,
Occupancy, LLOccurence, LLAggregate, DescOfOperation, LLPremium, LLRate,
LLReceipts, NOAEachOcc, Symbol, PolPremium, PolTax, PolSurcharge,
[FI-SubDivision], [FI-NameOfPerson], [FI-ProtectiveSafeguardDesc],
[FI-TerrorismDate], [FI-TerrorismPrem], [FI-EstimatedDate],
[FI-EstimatedPrem], [FI-TerrorismPremCertAcct], [FI-TerrorismPrem_Notice],
[FI-FireFollowingPrem], [FI-MVLiabilityInsPrem], PolicyDescription )" & _
"SELECT InsuredName, TradingAs, InsuredAddress1,
InsuredAddress2, InsuredCity, InsuredState, InsuredZip, BusDesc, BrokerCode,
BrokerName, BrokerAddress1, BrokerAddress2, BrokerCity, BrokerState,
BrokerZip, InsCo, PolNumber, PolType, PolEffDt, PolExpDt, DedEachOcc,
EnhanceEndDeductible, WindDeductible, ReplacementCostValue, ActualCashValue,
GLGenAggregate, GLProdCompOpsAgg, GLPersonal_AdvInjury, GLEachOccLimit,
GLFireDamageLimit, GLMedicalExpenseLimit, Exposure, Rate, Premium,
Occupancy, LLOccurence, LLAggregate, DescOfOperation, LLPremium, LLRate,
LLReceipts, NOAEachOcc, Symbol, PolPremium, PolTax, PolSurcharge,
[FI-SubDivision], [FI-NameOfPerson], [FI-ProtectiveSafeguardDesc],
[FI-TerrorismDate], [FI-TerrorismPrem], [FI-EstimatedDate],
[FI-EstimatedPrem], [FI-TerrorismPremCertAcct], [FI-TerrorismPrem_Notice],
[FI-FireFollowingPrem], [FI-MVLiabilityInsPrem], PolicyDescription " & _
"FROM tblSNMain WHERE ID = " & tempID

 

[T Best]

nevermind i got it. i was trying to access the recordset from the SQL
without knowing. i had the code from a previous attempt accessing it. i
deleted it and added the docmd.runsql command and it worked like a charm.