You have to hard-code in the team names? Aren't they in the database?

Ok, You might want the value stored behind the text in the teams list box to be the team's ID number. I assume all the players on the same team have the same team ID. This will allow you easily search the players DB for all players with the same correct team ID. You could use SQL (not sure if it will work with your database - I think it has to be ODBC) or just code the search yourself, by searching for all the players in the team, and maybe putting them in their own recordset. Or keep track of their record numbers (or player IDs if they have them), or maybe the records' bookmarks (something I'm having trouble with - I might be wrong about bookmarks). It really depends on what you're familiar with.

Once you've identified your team members, You should be able to stick 'em in your second list box without too much trouble.

When you've finished editing that team, I'd update the records in your main player database, if you made a separate recordset for them.

Hope this helps.