There are lots of methods. Basically, set your report's record source to a
query or SQL string that has a criteria.
I prefer to open all reports with code using the OpenReport method. This
code can be created with a command button wizard. I add a Where Condition to
this method to automatically apply a filter to the report's record source.
If you don't care about user-interface, you can use a parameter prompt in
your query.
