Parameter List Query

[Guest]

I am updating someone else's Access file. I'm currently using MS Access
2003. I would like to know how I can create a Parameter query where the
parameter is actually a list resulted from another query.

For example, I want to get address/phone numbers for only one specific
person. I would need to get a list of all people in the DB for the user to
select. Once selection is made, the selection would serve as a parameter
into my query.

Any help would be greatly appreciated.
Deluth

 

[Dave M]

A form with a list box based on the first query (people, presumably with a
PK like PersonID) should do the trick. When you select a person from the
list, your second query can use the list box value as its parameter:
Forms![MyForm]![MyList]