Saving more than one participant

[Guest]

hello,

I have a sub form within a main form. I have a list box with a bunch of
participants. One person, activity and function can have many participants.
On the sub-form I would like to be able to choose more than one participant
for each person. Right now I am able to choose one participant and it saves
this information in my participant table. How can I choose two in the list
box and that in turn saves this information to my table.

Thanks

 

[Mal Reeve]

Making more than one selection from a list box is a simple process
On the OTHER tab of its property sheet look for MULTI-SELECT..
you have options of none (only selected one)
Simple (select as many as you like) &
Extended (Select as many as you like but have to hold down shift or cntrl to
do it)

however how you then store this is interesting...
I'm not sure I understand how a single person has a participant? or what
that really means?

it sounds a little like another subform would be in order.
1 person and many participants...
thus having a table that holds the personID, and the ParticipantID
with the details being shown in this subform.

hth
Mal.