title: Syntax error: Missing operand after 'ID' operator
body: <p>i know theres loads of posts with this problem, but i cant seem to find the error in my code, any ideas?</p>
  
  <p>heres my code:</p>
  
  <pre><code>Private Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click
      On Error GoTo SearchErr
  
      If txtSearch.Text = "" Then
          Exit Sub
  
      Else
          Dim cantFind As String = txtSearch.Text
  
          MainBindingSource.Filter = "(Convert(ID, 'System.String') LIKE '" &amp; txtSearch.Text &amp; "')" &amp; _
              "OR (Student ID LIKE '" &amp; txtSearch.Text &amp; "') OR (First Name LIKE '" &amp; txtSearch.Text &amp; "')" &amp; _
              "OR (Last Name LIKE '" &amp; txtSearch.Text &amp; "')"
  
          If MainBindingSource.Count &lt;&gt; 0 Then
              With dgvStudentInfo
                  .DataSource = MainBindingSource
  
              End With
  </code></pre>
  
  <p>Im trying to search an Access DB in Vb.net</p>