title: MS Access: two linked combo boxes on a form
body: <p>I have three linked dimensions (say color, type, and size of an animal) linked by a fact table.</p>
  
  <p>I would like to create a form with these three dimension choices in combo boxes, so when I select one for a new record, the other two combo boxes refresh with only available values.</p>
  
  <p>For instance, if I select a dog as a type, the color would show (white, black, orange) but not green, if I select size small, the type will not include a whale, etc. </p>
  
  <p>I know i can do in VBA but would like ideally to avoid writing code for this. </p>