Forms creating new entry where it shouldn't

[Bilakos93]

Hi all

A straightforward one I'm hoping...
I have a many to many relationship (TblStudents, TblTeams, TblStudentsToTeams). Students can be at 2 or more different teams and the teams can have 2 or more students.
I have created a form (where the user can navigate between the teams using a combobox and the arrows) containing a subform where they can view the members of each team.
When I want to create a new team, I can do that easily using the main form.


My problem is: when I am trying to add a student to a given team (using the subform) it creates a whole new team instead of using the existing one (there can't be spelling errors as I'm using a combobox). Any ideas??

Thanks in advance

[davegri]

Have a look at

Many-To-Many, two ways to update Junction table, includes Not In List handling (accessforums.net)

[Welshgasman]

Is the form bound?
Show the code?

[Bilakos93]

I'm actually attaching the file
After fiddling around a bit I get the error message you'll see

Thank you

db.zip

[mike60smart]

Hi

Study the relationships and frmTeams in the attached