title: MS access- click a button, open a parameter (dropdown with options, not dates), open report based on selection
body: <p>The title may have been unclear, but I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select from the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. Any advice? I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from. </p>
  
  <p>I would need a few steps of help with most of the process as Im trying to reverse engineer from an established report and query it by a new set of parameters.</p>