title: Dlookup returning "error" I am unsure what is wrong with the formula
body: <p>I'm trying to put a formula in a form to return the &quot;Account Balance&quot; value from the &quot;credit limit&quot; query based off the &quot;Customer or Vendor&quot; selection in the form, which are listed as the &quot;business partner&quot; in the query .</p>
  <pre><code>DLookUp(&quot;[Credit Limit]![Account Balance]&quot;,&quot;[Credit Limit]&quot;,&quot;[Credit Limit]![Business Partner] = &quot; &amp; [Customer or Vendor])
  </code></pre>
  <p>Here is my Query, the name selected in the form matches &quot;business partner&quot;, I want to rerun the &quot;account balance&quot; value</p>
  <p><a href="https://i.stack.imgur.com/Av4jt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Av4jt.png" alt="enter image description here" /></a></p>