User defined SQL searches...?

[protagonist]

Hello,
I have an Access 2000 database for a library, with the entries you would expect: Author, title etc.

now, My question is: I want to write a query where it will give the details for a specified author, eg, we want a list of all the books by Douglas Adams.

Now, I know theres a quick-and-easy way to do it (rather than writing a query for every author, which seems a little inelegant )

So I want to be able to run the query, for it to ask me who I want to search for, and then do it. All I need to know is how to do the user-interface bit...Can't remember or find anything on it

Thanks

 

[PHV]

Take a look at Parameter when in the Query design window.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ulteriormotif]

Design your query with the fields you want to show up.

Create an unbound form with a combo box that lists your author names and place the reference to the combo box in the criteria row of the query, eg:

Like [Forms]![queryform]![cmbauthor]

Throw a button on the form to open your query.