| A common technique that I use to make a more | | | | manually, one at a time. |
| professional looking user interface for filtering data for | | | | Step 3 |
| a report in an MS Access database, is to create a | | | | Create a form with a text box for the starting date |
| form to ask for criteria for the report. One example | | | | and anothertext box for the ending date. Use the |
| would be a report that is used to show data for a | | | | button wizard to add abutton that will preview the |
| particular time period. | | | | report created in step 2. |
| Step 1 | | | | Step 4 |
| Create a query to feed data to the report. Add any | | | | Change the parameters in the query to this style: |
| necessaryparameters (like the "between [start_date] | | | | Between [forms]![myform]![txtStartDate] and |
| and [end_date]" style) and test. | | | | [forms]![myform]![txtEndDate]making sure you use the |
| Step 2 | | | | actual names for the form "myform" and the text |
| Create the report, using the query from step 1 as the | | | | boxes "txtStartDate" and "txtEndDate". |
| recordsource. Test the report thoroughly. Obviously, | | | | That's it. And, no VBA coding was required. |
| you will have toanswer the parameter questions | | | | |