Running query based on selection in list box

B

Bert

I have a form with a list box filled with names of people from a
query. I want to allow the user to select the name and then
automatically run the query and filter for that person's name only,
i.e. the selection that was made in the list box. How do I do this?
 
J

John Vinson

I have a form with a list box filled with names of people from a
query. I want to allow the user to select the name and then
automatically run the query and filter for that person's name only,
i.e. the selection that was made in the list box. How do I do this?
Click to expand...

If your Form is named frmMyForm, and the listbox named lstPeople,
create a Query with a criterion

=[Forms]![frmMyForm]![lstPeople]

Base a Report or a Form on this query to show the hits.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top