Updating a Table

[ssMaj]

I have a table with a field called "Stat" with a numeric value. Then on a form i have a Command Button. What i would like to do is every time the Button is clicked, is to add 1 to that "Stat" value. Not sure how i would do that..???

 

[randy700]

Perhaps an update query in the button On_Click event?


Randy

 

[Remou]

1. This is the SQL forum.
2. Why would you wish to do that?

 

[ssMaj]

I'm doing an UPDATE statement, but the WHERE clause is not working... I want it to UPDATE ASSOC_ID where ASSOC_ID = cboAssociate.value....but it doesnt like that

 

[randy700]

If you post the SQL, we might be able to see what's wrong with your query/code.


Randy

 

[ssMaj]

Thank you to Everybody that Replied. I figured it out...I had to make the where clause like this..

"UPDATE.....WHERE DEPEND_ID = '" & cboDependent2.Value & "';"