Getting Reports to show only certain data

[CR08RTS]

Hi

I am needing a bit of help creating a report. I have a field in my table and form named 'Media permission given' with a drop down list to select either Yes or No.

I want to capture in report form who has not given media permission.



So i guess the question is how do i create the report to only show the list of people who have 'No' selected in the field? Currently i have a report that lists everyone in the database and a mixture of Yes's and No's.

Any feedback would be a real help

Thanks, Chris.

[RuralGuy]

Use the WhereCondition argument of the OpenReport command to apply your filter. They work really well on reports.

[CR08RTS]

Thanks for the response!

The WhereCondition? i am not familiar with this, where abouts would i go to apply this filter to my report?

[RuralGuy]

From VBA Help:
expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
Have you checked VBA help yet? How are you opening the Report?