title: Pulling Data Out of A ComboBox
body: <p>I have a ComboBox that is being populated by a table, but when I have my ComboBox populated I have it concatenated with some formatting.</p>
  
  <pre><code>Do
      strValue = "Loc: " &amp; .Fields(0).Value &amp; " Weight : " &amp; .Fields(1).Value
  
      cbAlloys.AddItem strValue
      rsDB1.MoveNext
  
  Loop Until rsDB1.EOF
  </code></pre>
  
  <p>So now that it's like this I need to take just the weight value and output it without anything but the weight number.</p>
  
  <p>I tried this:</p>
  
  <pre><code>siBinWeightDescription.Value = cbBinAndWeight.Value
  siBinWeightDescription.Value = InStr(6, cbBinAndWeight.Value)
  </code></pre>
  
  <p>But, later realized that <code>Instr</code> only outputs the count.</p>
  
  <p>How would I go about getting the weight value I need from the ComboBox?</p>