am inserting data into a table
table fields name is correct
form textboxes names is correct
what's wrong?
table fields name is correct
form textboxes names is correct
Code:
strsql101 = "insert into tbl_Clients (ClientName, Username, Phone, RegistrationDate, RechargeDate, ExpiryDate, Address, Section, Account, AccountDealerCost, AccountResellerCost, AccountResellerSell, Netflix, Sama, Reseller, Company, Gift, Double, Linked) Values ('" & Me.txt_ClientName & "', '" & Me.txt_Username & "', '" & Me.txt_Phone & "', '" & Me.txt_Registration_Date & "', '" & Me.txt_Recharge_Date & "', '" & Me.txt_Expiry_Date & "', '" & Me.txt_Address & "', '" & Me.cbo_Section & "', '" & Me.txt_Account & "', '" & Me.txt_Account_Dealer_Cost & "', '" & Me.txt_Account_Reseller_Cost & "', '" & Me.txt_Account_Price & "', '" & Me.txt_Netflix & "', '" & Me.txt_Sama & "', '" & Me.txt_Reseller & "', '" & Me.cbo_Company & "', '" & Me.tgl_Gift & "', '" & Me.tgl_Double & "', '" & Me.tgl_Linked & "')"
DoCmd.SetWarnings False
DoCmd.RunSQL strsql101
what's wrong?