Multiple selections form either a combo or list box

  • 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?
 
Try creating a Form whose RecordSource is "Team Members"
with the list (or combo) box holding the full list of
master names and make this form a sub form of your Project
form. The link between the Project Form and the Team
Members subform should be the unique prject identifier.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top