title: MS ACCESS - How to get the current columns values of an unbound combobox on Change event
body: <p>I have an unbound combobox with 3 columns: item, sn and cost.</p>
  <p>I added a Change event on it and when i select one row from the drop down combo, i need the 3 current values all together in a textbox and separately in other texboxes.</p>
  <p>Ex: i click on the combobox and choose a random row from the list</p>
  <pre><code>Private Sub combo_Change()
  textbox1.value = 'current column1+col2+col3 values
  text2.value= 'current col1 value
  text3.value= ' current col2 value
  text4.value= 'current col3 value
  end sub
  </code></pre>
  <p>how can i do that?</p>