The only time I had this kind of situation where I was using the GUI rather than VBA, I had a combo that allowed me to tell the form "Select this user." Then when the selection had been made, a different combo would select whatever was the other possibility (in this case, a group). So once I made that selection, the user selected for the form was one side of the junction table and the group from the combo was the other side.