Selecting Multiple Entries to a field

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

John Z

I am trying to create an entry from a list of names. How
do I display a list of names in a form and select multiple
names for a field entry. I want to create a field of team
members from a list of names on a form.
 
John,

If I understand you correctly, you need to have a field in the same
table a the people's names, to identify the team (this assumes each
person can only be a member of one team... if a person can be in more
than one team, you will need to do it differently). It is best to
allocate the team to the person on a form based on the person table.
This can be a continuous view form, and you cna have a combobox to show
the teams that the person can be allocated to. But then, you can also
put a continuous view form based on the people table, onto the Team form
as a subform. This way, on the Team form, you will see a list of all
members of the current team... but you won't be able to edit the team
membership in this subform without the use of some vba procedures.
 
Back
Top