By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Run report on query

P: n/a
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

Aug 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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.

Aug 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.