Run report on query

[Eric]

I run a report on the basis of query. I dont know how to i use filters
in my report. I mean i have to ask user information in a drop down list
and on the basis of that information i want to generate the report.
Needs Help

[pietlinden]

Eric wrote:

I run a report on the basis of query. I dont know how to i use filters
in my report. I mean i have to ask user information in a drop down list
and on the basis of that information i want to generate the report.
Needs Help

Where do you usually find dropdown lists? On forms. So build a form
with your dropdown list. On the form put a button that opens the
report. Pass the filter in the Open event. Something like

Private Sub cmdOpenReport()
DoCmd.OpenReport "reportname", acPreview, "[SomeFieldInReport]=
" & Me.Controls("MyDropdown")

End sub.