I am trying to set up an Access database to issue/process client feedback questionnaires. The main table is a list of 2000+ clients and these questionnaires will be sent out in batches ever month or so, about 150 per batch. The issue date is recorded in a date field. I need to be able to run off a number of reports for various bathches from time to time and for the convenenience of non-IT users I need to offer them a Parameter dialog inviting them to select the batch date they require from a drop down list rather than getting them to enter the date manually. The drop down list must look up the values in the table rather than be fixed. How do I do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 - browse facility in Parameter Dialog
- Thread starter CATRAINOR
- Start date
Create a blank form.
Add a combo box using the wizard - choose the option to look up values in a table and follow the wizard through.
Save the form and note the form name and the name of the combobox.
Create a query which selects the fields you want for your report.
In the criteria cell for the batch date put:
forms!formnamehere!comboboxnamehere
Base your report on this query.
Add a button to your form which runs the report.
Add a combo box using the wizard - choose the option to look up values in a table and follow the wizard through.
Save the form and note the form name and the name of the combobox.
Create a query which selects the fields you want for your report.
In the criteria cell for the batch date put:
forms!formnamehere!comboboxnamehere
Base your report on this query.
Add a button to your form which runs the report.
- Thread starter
- #3
- Status
