title: Best way to prompt for report parameters in microsoft access
body: <p>Lets say you are designing a sales report in microsoft access. You have 2 parameters: Startdate and EndDate.</p>
  
  <p>I can think of 3 ways to prompt the end user for these parameters when the report is run.</p>
  
  <ul>
  <li><p>Create a form with 2 Text Boxes and a button. The Button runs the report, and the report refers back to the form by name to get the start date and end date.</p></li>
  <li><p>Create a form with 2 text boxes and a button. The button runs the report but sets the appropriate filter via the docmd.openreport command. </p></li>
  <li><p>Base the report on a Query and define query parameters. Access will automatically prompt for those parameters one by one. </p></li>
  </ul>
  
  <p>Which is the best way to go?</p>