Guidance on grouping students and staff requested

Hi All--I just need some info on making a type of scheduling form in which users can easily assign students and staff to different groups or teams. Here are the tables:
tblStaff: StaffID, StaffLname, StaffFname, TeamID, (more staff-related fields)
tblStudents: StudID, StudLname, StudFname, TeamID, (more student fields)
tblTeams: TeamID, Team

During the school year, students will be grouped along with multiple staff members in teams. These groups may change.

Users would like a fast and easy way to change the TeamID values of students and staff--without having to open the student and/or staff entry/edit forms and click a combo or listbox.



Any guidance would be appreciated. Thanks!

You want to change TeamID en masse? All students and/or teachers with a TeamID will all move to the new TeamID? Then you need VBA code. A form would get user input for current TeamID and new TeamID and select teachers or students or both. Then code would update all records having current TeamID to new TeamID in the appropriate tabes. Problem is, what if new TeamID is already in use? And if the assignments are made individually this won't apply. I am afraid there may not be a shortcut for managing data this dynamic.

Here's a simple one, just select the staff and students you want to change (can be one, can be many, I am using multi select list boxes) then choose the team you want to transfer or assign them to and click the button.

Ooops, I forgot about multi-select listboxes (I've just never had to use them). Something was tickling back of my brain but I forgot to follow up. Will have to select each indivdual but can be done all at once on one form. Think this is fastest way for you do group updates and best way to go for your situation. Some have said very long lists (thousands) can cause problems, but I have not encountered that with any of my comboboxes. Am guessing your lists won't be so long.

Thanks rpeare. A simple one? That was a nifty piece of code; thanks for the attachment. And, thanks to both of you for your time.

I love list boxes, if you saw some of the stuff I'm doing with them you'd realize how simple this is