tinladie said:
How do I get a parameter query to return a list of values. For
example I want to search for a name, how do I get a list of names
from the query
If you mean you want to be able to pick from a list the name you are
searching for then you cannot do that with the simple self-prompting
parameters that queries provide. Those offer VERY basic and limited
functionality and are one of the first things you "outgrow" in Access.
What you need instead is a form that has a ComboBox on it and the ComboBox
provides the list of names. The user selects a name from the list and THEN
you run the query and the query references the ComboBox on the form as its
criteria parameter. Something like...
SELECT *
FROM NamesTable
WHERE NameField = Forms!FormName!ComboBoxName
