Fixed it, turns out the brackets around the newPass.Text didn't need to be there!

Code:
Dim SqlQuery = "UPDATE Users SET Password='" & newPass.Text & "' where Username='" & accountName & "'"