Multi-selection list box in a form

[princessdmb]

Hello,

I've created a database to track training courses. I'm having issues with selecting multiple trainers. I set up my table to lookup a "List" on the trainer column. I've entered 2 records into my form and it displays 6 records. See attach image.

What am I doing wrong? :banghead:

Please help

 

[princessdmb]

Here's the database

 

[SOS]

Change the List box's bound field from Trainers to Trainers.Value

 

[SOS]

Change the List box's bound field from Trainers to Trainers.Value

After testing, I was wrong. REMOVE the Trainers.Value field from the form's Record Source Query and the list box if bound to the Trainers field (no .value after it), it should work fine.