First, you should ask this question in m.p.a.adp.sqlserver or maybe in
m.p.a.reports. I don't see why you have choosen this newsgroup for this
kind of question.
Second, there is really no difference between a form or a report. First you
create a form with the drop-down box (and a command button to open the
report in preview mode or in direct printing mode) and then you create your
report the same way as you would create a form using parameters for its
source but instead of using controls on the report as the source for the
values of these parameters, you will use instead the controls on the first
form.
Of course, there are many ways of using parameters with a form; so by the
same token, there are also many ways of using parameters with a report. As
you don't say anything about the methods that you are already using with
your forms, it's hard to tell you more on that.