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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating Reports from drop down boxes
- Thread starter redcare
- Start date
Hi,
I do this as well, and have some interesting techniques.
First, I created a new table in the database which contains the names of the reports I want to display in a combobox.
Second, on the form to be used to create the reports, I added a combobox with the new table as the Row Source.
Third, some of my reports use different criteria. So, on the "After Update" event, I use code to check the report name that was selected. Then I set the necessary text boxes on the report for Visible=True (e.g., lstCounty.Visible = True <--- if county is required to generate the report)
Fourth, I use queries to generate the data needed for the report, and base the report recordsource on this particular query. When I then run the report, I like to pass the values selected by the user as a "filter". (I wrote an FAQ on this topic - see faq703-2657 under Access Reports).
HTH,
Randy Smith
California Teachers Association
I do this as well, and have some interesting techniques.
First, I created a new table in the database which contains the names of the reports I want to display in a combobox.
Second, on the form to be used to create the reports, I added a combobox with the new table as the Row Source.
Third, some of my reports use different criteria. So, on the "After Update" event, I use code to check the report name that was selected. Then I set the necessary text boxes on the report for Visible=True (e.g., lstCounty.Visible = True <--- if county is required to generate the report)
Fourth, I use queries to generate the data needed for the report, and base the report recordsource on this particular query. When I then run the report, I like to pass the values selected by the user as a "filter". (I wrote an FAQ on this topic - see faq703-2657 under Access Reports).
HTH,
Randy Smith
California Teachers Association
- Status
Similar threads
- Locked
- Question
- Locked
- Question
