Filter List box from List Box

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.
 
M

[MVP] S.Clark

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.
 

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

Top