Populating text box upon selecting multiple items in combo box

[docxyz]

Hi poeple,

Now I have a combo box "cbo_items" and a text box "txt_selectedItems", I want to populate text field with items selected from the combo box, every time i select an item it appears in text box and to be separated with comma, so text box appears like this ( item1, item2, item3), and after finishing the whole thing the result appears in lable "lbl_result" as "total items selected: 3 items", I appreciate your help, and I dont mind if the solution have a little of vba

 

[docxyz]

Hi, after I wrote this thread, I found many drawbacks to storing multiple selections in a single field, as it violates normalization, I'm thinking of another way to solve this problem now, I appreciate sharing you ideas with me, thank you.