title: MS Access Syntax error
body: <p>here is my code:</p>
  
  <pre><code>Text22 = DLookup("[Program_No]", "1_Supportive_Housing", "[Program_Name] = '" &amp; Replace([Me.Program_Name], "'", "''") &amp; "' And [BudgetYear] = " &amp; [Me.BudgetYear])
  </code></pre>
  
  <p>I am not sure what is wrong with it, but it keeps giving me the following error: </p>
  
  <blockquote>
    <p>Can't find the field | in your expression </p>
  </blockquote>
  
  <p>I have been trying to get rid of this error but nothing works.</p>
  
  <p>OnKeyPress, this event triggers. As the user writes, it should be able to lookup the value in the table and assign it to text22.</p>