title: Set value of multicolumn combobox to all columns after selecting an item?
body: <p>I have a multicolumn combobox with 3 columns in an Access 2013 form. If I choose one of the items in the combobox, the value that it gets set to is just the value from the 1st column. Is there any way to set the value of the combobox using VBA to all 3 values, just like when you were picking it? If you can't, then how can I set the value to the 3rd columns value instead of the first? </p>
  
  <p>This is what my combobox looks like:</p>
  
  <p><a href="https://i.stack.imgur.com/Y8chW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y8chW.png" alt="enter image description here"></a></p>
  
  <p>This is what it looks like after I select the first item:</p>
  
  <p><a href="https://i.stack.imgur.com/5kIRI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5kIRI.png" alt="enter image description here"></a></p>
  
  <p>Instead of just showing "1", I want it to show "1 | 2015 | 1.1" like it does in the dropdown list.</p>