title: MS Access Forms : How to dynamically change the select options in a combo box?
body: <p>My MS Access form has a two combo boxes, <code>c1</code> and <code>c2</code>. </p>
  
  <p>I need the <code>select options</code> in <code>c2</code> to change dynamically . . . when i select an option in <code>c1</code>. How can I do this ? </p>
  
  <p>Each value in <code>c1</code> matches multiple values in <code>c2</code>. So if I select <code>Mike</code> in <code>c1</code>, the <code>c2</code> should provide only those options that correspond to <code>Mike</code>. Right now <code>combo box c2</code> shows ALL options. </p>
  
  <p><strong>How can I restrict the options in <code>c2</code> based on what was selected in <code>c1</code> ?</strong> </p>
  
  <p>Thanks !!!</p>