title: Retrieve Value Using Key From a Collection in Access 2000
body: <p>I know this is a simple question but it's aggravating me. If I have a key/value pair in a collection but I can't seem to get the value out using the key. I can get the key using the value but not vice versa. Is there some magical way to accomplish this?</p>
  
  <p>For example:</p>
  
  <pre><code>Dim CycleList As Collection
  Dim Value as String
  Set CycleList = New Collection
  CycleList.Add 1, "Some Value"
  
  
  Value = CycleList(1)
  </code></pre>
  
  <p>I've also tried CycleList.Item(1) and it's the same result, Value = 1. </p>