Filter List box from List Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 14 Oct 2005 16:31 GMT

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.

Signature

Thanks As Always
Rip

Reply to this Message

[MVP] S.Clark - 14 Oct 2005 22:26 GMT

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.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

>I have 2 list boxes on frmGradeEnter.
> lstGroupSelect, lstStudentName
[quoted text clipped - 8 lines]
> but
> you must input that before you open the form or you get an error message.

Reply to this Message