Not sure how to explain as I don't realy understand, but I will try.
I have a subform ( in data sheet view ) that has a control "Team name" this is a combo box where the user selects a Team name. I have a macro that opens a popup form after update. This form allows the user to add team members to the team name and stores this in a table called "tblteams". The problem is the popup form will not add more than 1 record to the table. I guess it is not referencing the current record on the subform and adding the new data to that record set. I have tried changing the relationship but just can't seem to get it right. As stated above just learning very slowly.
Any help would be greatly appreciated.
I have a subform ( in data sheet view ) that has a control "Team name" this is a combo box where the user selects a Team name. I have a macro that opens a popup form after update. This form allows the user to add team members to the team name and stores this in a table called "tblteams". The problem is the popup form will not add more than 1 record to the table. I guess it is not referencing the current record on the subform and adding the new data to that record set. I have tried changing the relationship but just can't seem to get it right. As stated above just learning very slowly.
Any help would be greatly appreciated.
