title: I want to return "Customer Name" from "Customer Table" where "Active Customer ID" on my form matches "Customer ID" in "Customer Table"
body: <p><code>Table: Case_Info</code> holds the <code>Customer Reference</code> value that the case is assigned to, which is looked up from the Table: <code>Client_List</code>.
  <code>Table: Client_List</code> has a list of <code>Customer References</code>, along with all the customer information, including <code>[fName]</code>.
  The user interacts with a form called the <code>Portal</code> which has a SubForm feed called <code>Case - View</code>, and another SubForm within that called <code>Case View - Case Info</code>.</p>
  
  <p>I want the <code>fName</code> to be shown in the <code>Case - View</code> depending on the active <code>Case</code> record the user is looking at, matching via the <code>Customer ID</code>.</p>
  
  <p>I'm trying to use <code>DLookUp</code>, but I'm pretty sure I'm doing it wrong as I'm trying to get the information from a combo box which feeds from a query.</p>
  
  <p>This is returning <code>#Name?</code> :
  <code>=DLookUp("[fName]","[Client_List]","Forms![Case View]![cmbCustRef] = '" &amp; [Client_List]![ClientID] &amp; "'")</code></p>
  
  <p><img src="https://i.stack.imgur.com/qhd1d.png" alt="See image"></p>