Generate report based on selected value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davidbennett@gmail.com - 28 Apr 2006 23:33 GMT

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

Reply to this Message

John Thomas Smith - 28 Apr 2006 23:52 GMT

>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

Reply to this Message