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 &...