Update MS Access table

[hugh999]

I found the following code for updating a table in MS Access which works fine

OleDbUpdateCommand1.CommandText = _
                 "UPDATE tblStats SET CarNames=" & _
                 "'" & TextBox1.Text & _
                 "' WHERE ID=" & IDTextBox.Text & "  ; "

How can I expand this to update other data on the same row. Example: Update the field “CarReg” from TextBox2.Text and update the filed “Speed” from TextBox2.Text

Thanks

 

[ousoonerjoe]

The piece you're looking for is the comma separating the fields and values.

OleDbUpdateCommand1.CommandText = "UPDATE tblStats " & _
				" SET CarNames= '" & TextBox1.Text & "', " & _
					" CarReg = '" & TextBox2.Text & "', " & _
					" Speed = '" & TextBox3.Text & "'" & _
				" WHERE ID= " & IDTextBox.Text & " ;"

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[hugh999]

Thanks, works great