title: Filtering a Listbox based on Combobox selection
body: <p>I have two tables: Person and Shift</p>
  
  <p>Person has as lookup field which is a one to many relationship with Shift.</p>
  
  <p>I would like to create a form in which a listbox displaying records from Person is filtered based on the selection of a combobox containing the records from Shift.</p>
  
  <p>in other words, i want to select "days" (value 1) in the combobox, and have only the records from Person that have value 1 in their Shift field displayed in the listbox?</p>
  
  <p>the equivalent sql would be something like:</p>
  
  <pre><code>SELECT * FROM Person WHERE Person.Shift = (the value of the combobox here)
  </code></pre>
  
  <p>Also, if possible, i would like to do this with little to no VBA as the person i'm passing this off to has no VBA experience and can't be expected to fix bugs in the VBA code.</p>