title: DLookup in Access form not working
body: <p>I am working with a form (Numbers Entry) that inputs information into a table (Numbers).  The first field in the form is a combo box (Property Initials) that allows the user to choose which property he is entering information for.  I am trying to setup a textbox on the form that will provide information (# of Models) from another table (Property Info) based on which property is chosen from the first field, which is the combo box named Property Initials.  I believe <code>DLookup</code> is the best way to do this, and have been trying to no avail to get it to work properly.  Currently I am using the following:</p>
  
  <pre><code>=DLookUp("[# of Models]","Property Info","Property Initials = " &amp; [Forms]![Numbers Entry]![Property Initials])
  </code></pre>
  
  <p>This returns an <code>#error</code> and I've tried about a gazillion different methods and none have worked.  Any help would be greatly appreciated.</p>