Starting a query using a drop down list box

[ATanker62]

Hello
Access 2000

I have three tables, Genre, Titles and Counts, Submissions. I wish to
create a query that will upon start up prompt me for the Genre, display a
dropdown box that I can pick the correct Genre, then display for me all the
Titles that have be submitted by that Genre selection. I have the guery it
prompts me for the Genre entry but I have no idea on how to create a dropdown
box that I can use to fill the query box.

 

[Roger Carlson]

You can't create a dropdown box in a parameter query. Your best bet is to
create a small form with all of your combo boxes on it, then run the query
referencing those boxes.

On my website (www.rogersaccesslibrary.com) are two small sample databases
that will get you started. "ParaQuerySelect.mdb" shows how to do the above.
"CascadingComboBoxes.mdb" shows how to limit the value of one combo box
based on another (which is also what you want to do).

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Rick B]

You would have to create a new unbound form and place the dropdown control
on that form. Then, the query would have to pull the parameter from there.

If you will do a search (which you should always do before posting a new
thread) you will find tons of very similar issues in this newsgroup. Many
of the responses will give you step-by-step instr4uctions, some will point
you to samples.

For a quick example, open the Northwinds database that comes with access and
run any of the reports from the main menu. I believe all of them (or at
least most of them) pop up a parameter form first.

Rick B