Filter a Report Access 2003

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

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
 
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
 
Bingo Thanks

Allen Browne said:
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
Click to expand...
 
Back
Top