title: Syntax error (missing operator) in query expression on vb/access
body: <p>I've been looking for an answer but I can't understand them since I'm noob on visual basic (I haven't been taught how to use it in school, I just search on the net to learn).</p>
  
  <p>Here is my problem: <code>Syntax error (missing operator) in query expression 'pinN='.</code></p>
  
  <pre><code>Dim con As New OleDbConnection("PROVIDER = Microsoft.ACE.OLEDB.12.0;Data Source =   C:\Users\Billy Otsuka\Desktop\VB Fiiles\Prototype-Prototype\Sample.accdb")
  Dim cmd As OleDb.OleDbCommand = New OleDbCommand("SELECT * FROM [Table3] WHERE pinN= " &amp; TextBox1.Text &amp; "", con)
  con.Open()
  Dim sdr As OleDbDataReader = cmd.ExecuteReader()
  If (sdr.Read() = True) Then
      adminLogin.Show()
      Me.Hide()
  Else
      MsgBox("Invalid pin")
  End If
  </code></pre>
  
  <p>The highlighted word is <code>sdr As OleDbDataReader = cmd.ExecuteReader()</code></p>
  
  <p>In this code I want to enter a 4 number pin and if its correct I can go to the next form but if its wrong it will not.  I'm using an access database.</p>
  
  <p>I really appreciate if anyone can tell me what's wrong since i don't have any idea what the error is. </p>