User selected filtering of forms

[workingpoor]

Ok I don't think this is hard I just can't seem to figure it out.

My goal:
Design a report that the user is able to select a semester from a combo box that will then filter the report to show only the selected semester.

What's going on:
Currently the report is generated out of a query that gathers data from several tables.

I know there is a solution but I don't know what the effect that I am looking for is even called. Any suggestions

 

[elbweb]

http://www.access-programmers.co.uk/forums/showthread.php?t=111826&highlight=Report

look at this Thread, the second/third posts would probably help you out.