Selecting data to run a query by using a drop down list

[ATanker62]

Hello
Access 2000

I have the following tables: Publisher, Titles, Genre,
I wish to have a query that will return the following information, Title of
work, Publisher Submitted to, but I wish to use the information from the
table Genre to start the query. So when I start the Query a drop down list
should appear that will allow me to select a value from the Genre table to
start the reteriving the information.

 

[Pat Hartman]

You'll need to make a form with a combo for Genre. Select something from
genre and run the query from the form. The query should reference the form
control.

....
Where Genre = Forms!YourFormName!txtGrnre;