Allowing Multiple Selections

[Voodeux2014]

I have a database that is currently set up and am trying to enable a feature, which i am pretty sure is possible.

Here is the structure:

tbl1Trainers (information needed for Trainers)
tbl1Campaigns (information for different campaigns that trainers could be assigned to)
tbl2Campaign_Trainers (currently set up to show relationship between campaigns and trainers)


frmMain (displays Trainer information on main form and has sub form that shows only the campaigns that are related to the trainer)
frmAssignCampaign (currently set up to where you have to select one trainer and one campaign)

This is where I am asking for help...I would like to be able to select multiple campaigns on the frmAssignCampaign instead of having to select one then save and then select a different one and click save and so on. I was thinking that a list box would suffice, but when clicking save it just displays the trainer's ID number in the tbl2Campaign_Trainers table and has a blank CampaignID. What is the best way to get this functional?

[June7]

Options:

1. combobox and just move to new record and select item

2. VBA code that loops through the listbox and saves records

3. multi-value field - I NEVER use them

[Voodeux2014]

I think that the listbox sounds like it would be easiest for the end user. I will try to set that up. Thanks!