Parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
 
Back
Top