title: Function DLookup in Ms Access 2016
body: <p><img src="https://i.stack.imgur.com/NjfE4.jpg" alt="This code"></p>
  
  <p>gives me </p>
  
  <p><img src="https://i.stack.imgur.com/kVVbn.png" alt="this error"></p>
  
  <p>when saving records in the system.</p>
  
  <p>Can anyone let me know what is the problem in this?</p>
  
  <pre><code>xx = DLookup("[part_number]", "tblModelCost", "[Customer_ID]= " &amp; me.Customer_ID &amp; " and [Model] = '" &amp; me.[txtModel] &amp; "' and [Description] = 'screen'")
  </code></pre>