Hello again,
Can someone tell me how to edit/update/delete record on the Form View?

i got this on my Update COMMAND :

Code:
UPDATE agent SET Code = ?, Name = ?, Addr1 = ?, Addr2 = ?, Addr3 = ?, Addr4 = ?, PhoneNo = ?, HPhoneNo = ?, FaxNo = ?, OperateNo = ?, PhoneModel = ?, GroupCode = ?, CreateBy = ?, Remark1 = ?, CreatedDateTime = ? WHERE ID = ? AND Code = ? AND ((Name = ?) OR (Name IS NULL AND ? IS NULL)) AND ((Addr1 = ?) OR (Addr1 IS NULL AND ? IS NULL)) AND ((Addr2 = ?) OR (Addr2 IS NULL AND ? IS NULL)) AND ((Addr3 = ?) OR (Addr3 IS NULL AND ? IS NULL)) AND ((Addr4 = ?) OR (Addr4 IS NULL AND ? IS NULL)) AND ((PhoneNo = ?) OR (PhoneNo IS NULL AND ? IS NULL)) AND ((HPhoneNo = ?) OR (HPhoneNo IS NULL AND ? IS NULL)) AND ((FaxNo = ?) OR (FaxNo IS NULL AND ? IS NULL)) AND ((OperateNo = ?) OR (OperateNo IS NULL AND ? IS NULL)) AND ((PhoneModel = ?) OR (PhoneModel IS NULL AND ? IS NULL)) AND ((GroupCode = ?) OR (GroupCode IS NULL AND ? IS NULL)) AND ((CreateBy = ?) OR (CreateBy IS NULL AND ? IS NULL)) AND ((Remark1 = ?) OR (Remark1 IS NULL AND ? IS NULL)) AND ((CreatedDateTime = ?) OR (CreatedDateTime IS NULL AND ? IS NULL))
but when i click the update command , it return this error message ...pls help.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, Name = ?, Addr1 = ?, Addr2 = ?, Addr3 = ?, Addr4 = ?, PhoneNo = ?, HPhoneNo =' at line 1