title: Run-time error '2465' ...can't find the field '|1' referred to in your expression
body: <p>I keep getting the message <code>Run-time error '2465' ...can't find the field '|1' referred to in your expression</code> and I have no idea where to find the cause, please help!</p>
  
  <pre><code>DoCmd.OpenForm "JournalDetailsDrilldown", acNormal, , "SQL_Where" And [Plymouth - Nominal Detail]![Client Ref] = " &amp; Forms!MainMenu![Client Ref] &amp; "
  </code></pre>
  
  <p>the one below is working now
      DoCmd.OpenForm "JournalDetailsDrilldown", acNormal, ,SQL_Where &amp; " And [Client Ref] = " &amp; Forms!MainMenu![Client Ref]</p>
  
  <p>error message sorted, many thanks to Jacouh!!1</p>