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.

Have you looked into a list box with the MultiSelect property set to True? Perhaps you can work something out there...

hth

I must admit I hadn't. Not sure how it'll fit in a continuous form but thanks.

Another method might be a command button that can run some SQL to modify records based on a clause. I'm not exactly sure what data you're trying to manipulate, but maybe something like this:

Thanks, I'll look at that too.