Filter List box from List Box

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

Guest

I have 2 list boxes on frmGradeEnter.
lstGroupSelect, lstStudentName

I have a list of groups in lstGroupSelect, got that no problem.

I want the selection in lstGroupSelect to filter the Students in
lstStudentName to only the ones who are in the group selected in
lstGroupSelect.

How do I do that? I tried making a query that read the lstgroupSelect, but
you must input that before you open the form or you get an error message.
 
The IN clause is good to use. Parse the first listbox's selection and fill
them into an IN clause.

ItemsSelected property, I think. See the help file for more info.
 
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
Populating text box using selections from multiselection list box 2
Adding a lookup list to further filter form results 1
Controlling a list box population based on combo boxes 1
filter listbox from a cbo box. 1
Combo Box Filter 1
Filtering a List 3
Selecting First Row of List Box 17

Back
Top