Need macro to show information in a report only when critera are meant

[superchew]

Hi,
I need a macro that will show a information on report from a form only when certain information on the form = certain criterea. for example, if the form box says yes then the in formation in box 2 shows up in the report if box says no then the information is left black from the report.

[alansidman]

Build a query and set the criteria in the query for the field holding the specific data to "Yes". Use the query as the record source for your report.

[:) Sixthsense :)]

As an another option you can use (Report) Filter property also

[superchew]

how would i do this.

[:) Sixthsense :)]

how would i do this.

Not sure to whom it's refers to?

[superchew]

you and alansiman both? not sure how to do either of your suggestions.

[:) Sixthsense :)]

Check whether the below links helps you

http://ms-access-tips.blogspot.in/20...ng-filter.html

http://office.microsoft.com/en-in/ac...005188170.aspx

[alansidman]

Here is a short tutorial on building a parameter query

http://www.databasedev.co.uk/parameter_queries.html