Using the results of a Multiselect list

[Deb Smith]

I have a drop down list that includes the following fields.
PersonID
LName
FName
Name: [LName]&" ," & [FName]

I want to be able to select a number of records from this list and have the
selected people automatically populate a combo box(cboName) on the form. The
user will then be able to continue to enter other information about each
person.

What is the best way of doing this?????

What is the best way of:

1) selecting multiple records from the list at one time?
2) automatically populating the bound combo box with the info selected in
the list box, potentially creating many new records based on the selections
made.

Thanks in advance for the help. I really am at an impass.

 

[Jeff Boyce]

Deb

If you already have a listbox with the folks in it, couldn't you just pick
one and do the "enter information" step, without using an intervening combo
box? What business need are you solving by adding that extra step?