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

Generate report based on selected value

P: n/a
Hello,

I am new to MS Access. I have created a series of forms that users
access to perform data entry. I now need to build in reporting
functionality. I would like to create a form that has a drop down box
where the user selects a value and then clicks a "generate report"
button where data about the selected value is presented in a report.
Can someone help get a beginner started on accomplishing this?

Thanks,

David

Apr 28 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 28 Apr 2006 15:33:39 -0700, da**********@gmail.com wrote:
I am new to MS Access. I have created a series of forms that users
access to perform data entry. I now need to build in reporting
functionality. I would like to create a form that has a drop down box
where the user selects a value and then clicks a "generate report"
button where data about the selected value is presented in a report.
Can someone help get a beginner started on accomplishing this?


Quick example

A data control on the form named something like... dataHere
(the form is named PrintForm)

A Query with code something like [forms]![PrintForm]![dataHere]
in the field you use for selection... the query will not compare
the information in the field dataHere on the form, and will
return only the information that matches (the code above goes in
the Criteria row in the Query)

Build your report based on the Query
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Apr 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.