Update Multiple Records

[anwaar]

Dear Friends,



I am using following code to update 1 record in a table named "Evaluators", but this code is updating two records instead of one. It updates my required record and 1st record as well But I want to update only my required record. Kindly guide me.

Private Sub UpdatePassword_Click()
DoCmd.RunSQL "UPDATE Evaluators SET Evaluators.[Password] = EditPass.value WHERE (((Evaluators.Username)=Username.Value));"
End Sub

[RuralGuy]

Try:

Private Sub UpdatePassword_Click()
DoCmd.RunSQL "UPDATE Evaluators SET Password = '" & Me.EditPass & '" WHERE Username = '" & Me.Username "';"
End Sub

[ssanfu]

What type is "EditPass " (text, integer, long)?

What type is "Username" (text, integer, long)?


You need to concatenate the values. If EditPass and Username are text, it should look like this:

Private Sub UpdatePassword_Click()
DoCmd.RunSQL "UPDATE Evaluators SET Evaluators.[Password] = '" & EditPass & " WHERE Evaluators.[Username] = '" & Username & "';"
End Sub

Note the delimiters......

[RuralGuy]

Hmm...isn't that what I just said?

[ssanfu]

Hmm...isn't that what I just said?

Yep... I was interrupted while trying to post, by that 4 letter word - Work! I hope I did't offend anyone

So I didn't see your post, since I couldn't/didn't refresh the screen...... I'll be faster next time

[RuralGuy]

No problem for me. I was just checking to see if I missed something.

[ssanfu]

Great minds think alike........


time....

[anwaar]

Dear ssanfu & RuralGuy,

I have tried both codes that were suggested by you but encountered with the same error "Syntax error". Kinldy help me.

(EditPass and Username are the values of two textboxes)

[orange]

Please post the exact code that is getting the error.

[anwaar]

Probelm solved but in a bit different way

[RuralGuy]

Do you care to share your solution with others that read this Forum?