title: Microsoft Access can't find the field '|1'
body: <p>I keep getting a run time error '2465' when running a query via VBA in Access.</p>
  
  <p>Error: Microsoft Access can't find the field '|1' referred to in your expression</p>
  
  <p>I can't seem to find where this issue is occuring. Below is the VBA code that I'm currently using to requery a form.</p>
  
  <pre><code>Dim Test As String
  Test = "*" &amp; Combo161.Value
  
  Dim strSQL As String
  Dim strWhere As String
  strWhere = (Chr(34) + Test + (Chr(34)))
  
  'MsgBox (strWhere)
  
  strSQL = "SELECT * FROM Test_Query WHERE TestID " &amp; strWhere
  
  'MsgBox (strSQL)
  [Form_Test (subform)].RecordSource = strSQL
  [Form_Test (subform)].Requery
  </code></pre>
  
  <p>The <code>TestID</code> had a field formatting of text, rather than a number. Does this matter at all?</p>