Kobus.Worx
New member
- Local time
- Today, 06:08
- Joined
- May 6, 2019
- Messages
- 4
This is my VBA code:
CurrentDb.Execute "UPDATE tbl_01_00_Suppliers " & _
"SET fld_01_00_01_Supp_Cd='" & Me.txt_D_SupplierCode & _
", fld_01_00_02_Supp_Name='" & Me.txt_D_SupplierName & "'" & _
", fld_01_00_03_Supp_Loc='" & Me.cbx_D_SupplierLocation & "'" & _
", fld_00_01_04_Supp_Tel='" & Me.txt_D_SupplierTel & "'" & _
", fld_00_01_05_Supp_Fax='" & Me.txt_D_SupplierFax & "'" & _
", fld_00_01_06_Supp_Email='" & Me.txt_D_SupplierEmail & "'" & _
" WHERE fld_01_00_01_Supp_Cd=" & Me.txt_D_SupplierCode.Tag
This is the error when attempting to execute:
Syntax error (missing operator)in query expression "THHOWN099, fld_01_00_02_Supp_Name='The Helpful Handyman', fld_01_00_03_Supp_Loc etc.
I suspect the fld_01_00_01_Supp_Cd after SET
Any help will be highly appreciated - thank you
CurrentDb.Execute "UPDATE tbl_01_00_Suppliers " & _
"SET fld_01_00_01_Supp_Cd='" & Me.txt_D_SupplierCode & _
", fld_01_00_02_Supp_Name='" & Me.txt_D_SupplierName & "'" & _
", fld_01_00_03_Supp_Loc='" & Me.cbx_D_SupplierLocation & "'" & _
", fld_00_01_04_Supp_Tel='" & Me.txt_D_SupplierTel & "'" & _
", fld_00_01_05_Supp_Fax='" & Me.txt_D_SupplierFax & "'" & _
", fld_00_01_06_Supp_Email='" & Me.txt_D_SupplierEmail & "'" & _
" WHERE fld_01_00_01_Supp_Cd=" & Me.txt_D_SupplierCode.Tag
This is the error when attempting to execute:
Syntax error (missing operator)in query expression "THHOWN099, fld_01_00_02_Supp_Name='The Helpful Handyman', fld_01_00_03_Supp_Loc etc.
I suspect the fld_01_00_01_Supp_Cd after SET
Any help will be highly appreciated - thank you