title: access combo box on a form to display text values from table/query and save the associated ID value in the table on my form is already based on
body: <p>My project is a form based on a transaction table,  this form has four combo boxes. Basically all of them are storing ID values, and the question is how to make access display the associated value of the ID on the form, while the ID# is being stored in the table.</p>
  
  <p>Example: one combo name is well_ID on the form, which will be populated from the table (Wells) by select staetment [SELECT Wells.Well_ID, Wells.Wellname FROM Wells]
  i need the combo to display the well name and store the well_ID  in the table.</p>
  
  <p>Would you please help on this. </p>
  
  <p>Regards
  Mohamed </p>