Selecting Multiple entries into one field

[John Z]

I would like to select multiple names from a master names
table into a field of another table labeled team members
through a form. Each entry is in the project table is a
separate project and a each project can have 2-5 members
and the members can either be the same or different from
project to project. How can this be accomplished?

 

[John Vinson]

I would like to select multiple names from a master names
table into a field of another table labeled team members
through a form. Each entry is in the project table is a
separate project and a each project can have 2-5 members
and the members can either be the same or different from
project to project. How can this be accomplished?

This takes some VBA code. You should NOT store the concatenated member
list in any table field; but you can use the code to generate the list
on the fly to be displayed on a form or report. See sample code at:

http://www.mvps.org/access/modules/mdl0004.htm