query criteria question

[damos2001]

Hello I am currently taking a database class and am working on class project and having problems with making a query. I have a database table that had customer names and shows books they subscribe too. I made a query where it ask you to type in the book name and it list all the names of people who are subscribe to this book. But what I am really looking to do is make it so I can use a drop down list like a combo box that list all of the books in a list then user just selects that book and it shows all the people subribed to it.

Is this at all possiable and is it even a query or a form I need to make for this ? I have been trying to search online for last 2 days on this but either it can not be done with access or I am not sure what I should being trying to search for.



I will warn I am a novice at access and databases. But thanks for any help anyone can give

[pbaldy]

Quite simple, but you do need to use a form. Have your query criteria point to the form/combo instead of [Whatever].

[damos2001]

I was trying to do this last night as that was what I was thinking I needed to do but I cant seem to figure out how to point a query to a form/combo. Any idea what kind of terms I should use to do a google search to try and find more info on how to do this.

[pbaldy]

You can right click and select Build or:

http://access.mvps.org/access/forms/frm0031.htm