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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List box populate based on combo box 1
Form that Runs a Query. 5
Dependant Multi-Selection List Boxes~HELP, I'm Stuck! 1
List Box Selection 7
Controlling a list box population based on combo boxes 1
combo box selection will not populate query correctly 1
Populating text box using selections from multiselection list box 2
List Box SOS 3

Back
Top