Selecting Multiple entries into one field

  • Thread starter Thread starter John Z
  • Start date Start date
J

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?
 
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?
Click to expand...

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
 
Back
Top