Firstly apologies if this is covered elsewhere. I have searched but couldn't find what I think I need.
I have an events form with a details subform where you can select pupils from a combo box. At the moment the bound column in the combo box is the pupil id. The school would like to be able to select a whole year or class and have all the names populated at once but would still like the ability to select names indiviually. Please can someone point me in the right direction. The underlying table has pupil id, year, class etc.