Select Command
jmcilhinney
Hope this is what you asked for.
Me.OdbcSelectCommand1.CommandText = "SELECT ""TransactionId"", ""Cono"", ""PolicyNumber"", ""InsuredName"", ""Address1"", ""Addre" & _
"ss2"", ""City"", ""State"", ""Zip"", ""EffectiveDate"", ""ExpirationDate"", ""ActivityDate""," & _
" ""PolicyType"", ""AgentNo"", ""CarrierNo"", ""Premium"", ""AgentCommission"", ""CompanyCom" & _
"mission"", ""TaxAmount"", ""PolicyFees"", ""FeesDueCompany"", ""StampingFees"", ""Underwri" & _
"ter"", ""CarrierContractNo"", ""FinanceCompany"", ""PremiumType"", ""AnalysisCodes"", ""Re" & _
"write"", ""SellingAgent"", ""SellingAgentLicenseNo"", SLA, NAIC, ""EntityType"", ""FSLSO" & _
"CoverageType"", ""County"", ""DataSource"", ""CountyCode"", ""MunicipalCode"", ""FireDistr" & _
"ictMunicipalCode"", ""FireDistrictISOCode"", ""OAStatus"", ""OAVendorCode"", ""Accountin" & _
"gDate"", ""CoverageType"", ""PolicyGroup"", ""LineOfBusiness"" FROM PUB.""TransactionHea" & _
"der"""
Me.OdbcSelectCommand1.Connection = Me.OdbcConnection1