Need to separate data in table taken from mult select list box 1

[miaka13]

I am extremely new at VBA coding. I am trying to put together a user friendly database in Access 2002 for my coworkers. I managed to get a code from this forum to work in my database. What I currently have my form doing is to take the information selected in my multi select list box and place it in a table. Unfortunately it is taking all of my selected data and placing it in one field on my table. I would like to put each selected item into a seperate field in my table. Can anyone help me? Please go easy on little old beginner me.

 

[miaka13]

What I ended up doing is building another table called tbl_Look using the "Look up Wizard" to look up the colors from the original color table. I then created a second field and called it JobUpdate that looked up the jobs from my original job table. Next I built my subform linking back to my tbl_Look. This created a drop down list box of colors. Now when the user selected the color it would send the selected color to my tbl_Look table along with what job it belonged to.