report or query problem?

[junkmale]

hi.

i'm doing a database for a library, and one of my reports shows all books written by a certain author.

what i'm doing now has a "popup" promting me to key in the author last name. This works.

But, i'm trying to improve on it.

Is there some way that will display a list/dropdown of authors for me to choose from?

 

[pbaldy]

Sure; create a form and put a combo box in it that displays a list of authors from the appropriate table. Then have the query criteria point to that form field instead of the pop up box.

 

[junkmale]

thanks for the reply, but i dun think i'll be using it due to time constraints in finishin up my database...

nevertheless many thanks!