Running query based on selection in list box

  • Thread starter Thread starter Bert
  • Start date Start date
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?
 
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
 
Back
Top