Hi, I really need help here...
I want to update an 'avaibility' as in yes/no in the database..
Its subjected to only that particular serial number...

Heres my code.

Dim cmdTemp As OleDb.OleDbCommand
cmdTemp = New OleDb.OleDbCommand
cmdTemp.CommandType = CommandType.Text
cmdTemp.Connection = cnnRental

cmdTemp.CommandText = "INSERT INTO Stock (existance) VALUES ('0')"[COLOR=red] <--- how do i add the clause "Where serial = txtSerial.text or '?' to make it to a complete statement?"

cmdTemp.Connection.Open() cmdTemp.ExecuteNonQuery() cmdTemp.Connection.Close