How to search via drop down boxes

[MaxP]

I am just starting out with a database and last night got more success than I imagined in that I have the basic database, a usable form and a report set up and displaying mostly as I want.

What I would like to do is to be able to look on a form and select certain criteria and only see records that fall into them.

The database is for magazines so for example I would like to be able to select "Prima" magazines and only see those, then maybe select 2005 and only see the Prima magazines i have from 2005,

What I want to know is if this is done by a Query or a Report or something else?



I have attached a copy of what I have (it is in Access 2007 format) and as I say I know it is basic and rough but it has to start somewhere. I want to understand things before I add too many entries and then find I have big problems on my hands.

Any help on where I am supposed to be looking would be appreciated

Thanks
Andy

Magazines.zip.

[June7]

Here is one method:
http://datapigtechnologies.com/flash...tomfilter.html

[Cal S.]

I believe that will work for my problem as well. Thank you. Good post.