title: Access Form show other table's fields of selected combobox item
body: <p>I am new to Microsoft Access. This is the structure I have:</p>
  
  <p>Table <code>Suppliers</code> with fields <code>Name</code>, <code>Address</code>, <code>Zip</code>, <code>PhoneNumber</code> <br>
  Table <code>Purchases</code> with fields <code>Supplier</code>, <code>Address</code>, <code>Zip</code>, <code>PhoneNumber</code>  (and some other irrelevant ones)</p>
  
  <p>The <code>Supplier</code> field in the <code>Purchases</code> table should contain a reference to a record in the <code>Suppliers</code> table.</p>
  
  <p>Now I am making a form so the user can enter <code>Purchases</code> records. It has a combobox to choose the <code>Supplier</code> and some text fields for <code>Address</code>, <code>Zip</code>, <code>PhoneNumber</code>. What I want is that when the user selects a <code>Supplier</code>, the values for the <code>Address</code>, <code>Zip</code>, <code>PhoneNumber</code> will be copied from the selected <code>Supplier</code> to the corresponding text fields in the form. </p>
  
  <p>How can I achieve this result using Visual Basic code?</p>