drop down selection

P

Pam Coleman

I have a startup form and I want the user to click on a drop down list and
choose the report they want. Is there a way to have one drop down and show
the years and they choose the year then click on another drop down and click
on the report. I have a report for Officer-Totals and then another one for
Officer-Sex-Race-Citation. I have a two reports for each year beginning with
2000. You can see if I create a command button I would have 2 for each year
and it would continue. Therefore, I thought if I had a drop down for year
and then for report, it would be less confusion on the form. Thanks,
 
Top