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.
 
Back
Top