-->>Hi everyone,I'm having this problem with updating records in my application my code is:
SQL = "UPDATE Ministers SET User_Name='" & txtUser_Name.Text & "',Password='" & txtRetype_Password.Text & "',Prefix='" & cmbPrefix.Text & "',Passport='" & NewPicture_Name & "';"
Set Conn = Nothing
-->>The SQL and Conn variables are declared alredy in module level
-->>Note:My Ministers table consists of Five Colums though,I just want to update only the one I stated.
-->>Iam receiving the "Syntax error in UPDATE statement" whenever I run my application
-->>Anything missing there?