title: Select certain rows from a result set. MS Access VBA
body: <p>This could be bit complicated. I will try to explain as much as I can.</p>
  
  <p>Say for example i have a table called "Job". In this table there will be multiple entries for a same Job ID (Job ID is not Unique). The current system enables a user to search for a particular Job ID and return all the rows having the same Job ID on a form as shown below:-</p>
  
  <pre><code>Job ID | Item Name | Date Completed | Generate Report?
  ------------------------------------------------------
  JB001     Door        25/12/2012          []
  
  JB001     Window      02/01/2013          []
  
  JB001     Blinds      10/01/2013          []
  
  JB001     Carpets     15/02/2013          []
  </code></pre>
  
  <p>I would like to implement a feature where a user can select multiple rows from this result set (using the check boxes) and generate another form/report form he selections. For e.g. if the user ticks check boxes next to Window an Blind and then clicks a button, the next form should display these selected rows. </p>
  
  <p>By the way, I am using MS Access.</p>
  
  <p>The problem I am facing is  haven't got a clue as to how to implement this i.e to select certain rows from the result set. </p>
  
  <p>Thanks in advance.</p>