dimanche 19 avril 2015

Trying to run an Update query but error in the syntax

I'm trying to create an update query:

v_sqlcommand = "UPDATE User SET User.Doctor = " & txt_doctor.Text & ", User.DoctorSurgeryAddressStreet = " & txt_streetname.Text & " WHERE User.UserID = " & UserID

but I keep getting a syntax error thrown at me. I have put in a breakpoint and ran the query from the debugger and it works when I run the query in access. I have checked the text box names and they are fine. Just a bit puzzled...

Aucun commentaire:

Enregistrer un commentaire