title: Access 2016 Form auto-populate based on another field
body: <p>I've got two  tables that contain the following.</p>
  
  <p><strong>Table Name: Enquiries</strong></p>
  
  <ul>
  <li><p>ID</p></li>
  <li><p>Username</p></li>
  <li><p>Date of Raising</p></li>
  <li><p>Time of Escalation</p></li>
  <li><p>Invoice</p></li>
  <li><p>Repeat Contact</p></li>
  <li><p>Query Type </p></li>
  <li><p>Context of Query</p></li>
  <li><p>DC</p></li>
  </ul>
  
  <p><strong>Table Name: PC</strong></p>
  
  <ul>
  <li><p>PCID</p></li>
  <li><p>PCarea</p></li>
  <li><p>Town</p></li>
  <li><p>DCArea</p></li>
  <li><p>DCName</p></li>
  </ul>
  
  <p>I currently have a Form setup with the above fields all selected. I have PCArea setup as a drop down as the field has 2000+ records (Postcodes). What I want is when a person updates this field/drop down/combo box for Access to lookup the PCArea and find out what the DCName is relevant to this and then populate the DC field in "Enquiries" and show on the form but I can't fathom how to do it.</p>
  
  <p>I know it's VBA related but I can't seem to get the format right?</p>
  
  <pre><code>Private Sub Combo472_AfterUpdate()
  
  Me.PCArea = Me.Data.Column(9)
  
  End Sub
  </code></pre>
  
  <p>Sure didn't work! Any help would be great.</p>