Multi-Select

[Guest]

I want to use a ListBox to select multiple students for tardy violations so a
teacher does not have to enter each student seperatly. The listbox would
come from an alpha query containing only the student name and student id.
The id field is stored in the table tbltardy as the primary key.

Can I use the multi-select option to store multiple kiddos at one time?

 

[Alex White MCDBA MCSE]

Dim varItem as variant

For Each varItm In lstSkills.ItemsSelected
msgbox lstSkills.ItemData(varItm)
Next varItm

would give you a msgbox for each item selected.

you would have to write some vba to write each item to tblTardy