title: how to populate textbox with the database value based on combobox change in access
body: <p>I am new to Access and vb and i have failed to get the result what i am thinking to get ,hope i will resolve with your help guys</p>
  
  <p>->my access database contains one table with following fields
                      <strong>firstname</strong> lastname <strong>middlename</strong> phone</p>
  
  <p>I have two combo boxes and two textboxes</p>
  
  <ol>
  <li>combobox- it populates firstname and based on this selection the other combo box has to fill with last name which i did successfully with the help of Me.Combo2.Requery</li>
  </ol>
  
  <p>but i dont know how to fill middle and phone in textboxes </p>
  
  <p>here i am failing in mapping recordset and connectionstring with my table and getting result to textbox value can any one help on this </p>