Generate report based on selected value

[davidbennett]

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

[John Thomas Smith]

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