Filter a Report Access 2003

[AJOLSON]

I am having a difficult time applying a filter to a Report. What I have is a
Report that's control source is a Query with several fields on the Report.
One of the fields is named JobFunction and that is the field I want to apply
the filter too.
What I would like is for the user to open a Report then from a drop down
list (Combo-box) select a the job function they want then the Report display
just those Job functions. Any help would be appreciated. Thanks

 

[Allen Browne]

You will need to use a form to do this.

Create a form with an unbound combo fo rselecting the JobFunction, and a
command button to open the report. The command button will use OpenReport,
with a WhereCondition that limits the report to just that one JobFunction.

Here's a basic example of a form that opens a report with a WhereCondition:
http://allenbrowne.com/casu-15.html

 

[AJOLSON]

Bingo Thanks

You will need to use a form to do this.

Create a form with an unbound combo fo rselecting the JobFunction, and a
command button to open the report. The command button will use OpenReport,
with a WhereCondition that limits the report to just that one JobFunction.

Here's a basic example of a form that opens a report with a WhereCondition:
http://allenbrowne.com/casu-15.html