How have you forgotten how to execute a query and pass a parameter since
yesterday[
^]?!
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Tech\LoanerTracking.accdb"
Using conn As New OleDbConnection(connStr)
Dim query As String = "Update TrackingInfo Set CheckedOut = 0 WHERE AssetBarcode = ? And CheckedOut = 1"
Using cmd As New OleDbCommand(query, conn)
cmd.Parameters.AddWithValue("?", TextBox3.Text)
Try
conn.Open()
cmd.ExecuteNonQuery()
MsgBox("Item Successfully Checked-In")
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Using
End Using
TextBox3.Text = String.Empty
TextBox2.Text = String.Empty
TextBox1.Text = String.Empty
End Sub