title: Access field is blank when value is not in combo box
body: <p>I have a form that has a field for "task performed" and a combo box of employee names to be picked from. The combo box links to a table with 3 fields:</p>
  
  <ul>
  <li><p>field1-autoid</p></li>
  <li><p>field2-employee_name</p></li>
  <li><p>field3-active(check box)</p></li>
  </ul>
  
  <p>In order to keep the combo box list small and more user-friendly it only lists employees that are active (ie. employed). The problem with this is that when we scroll back through the records the inactive employees merely show up as a blank because they are not in the combo box.</p>
  
  <p>Is it possible to get the field itself to still show the proper data but keep the combo box only listing active employees?</p>