title: How do I select values of a multivalue combobox using VBA in MS Access 2010?
body: <p>I have a MS Access 2010 form with a "Company" combobox and an "address" <strong>multivalue</strong> combobox.</p>
  
  <p>When a company is selected the AfterUpdate event requeries the address combobox so that only addresses relevant to the company are listed. This works perfectly; however the majority of companies only have one address value, so I want to automatically select the address if there is only one.</p>
  
  <p>I have spent a lot of time trying variuos methods such as:</p>
  
  <pre><code>AddressCombo.Value = AddressCombo.ItemData(0)
  </code></pre>
  
  <p>which brings up "Runtime error 3032" and the following doesn't appear to do anything.</p>
  
  <pre><code>AddressCombo.Selected(0) = True
  </code></pre>
  
  <p>I know using a listbox is better but I want to know if this can be done with a multivalue combobox.</p>
  
  <p>For those unaware of multivalue comboboxes (MSA 2007+), here is a video of them in action:</p>
  
  <p><a href="http://www.youtube.com/watch?v=queKMe9MiSs" rel="nofollow">http://www.youtube.com/watch?v=queKMe9MiSs</a></p>