Multiple Combo box selection

[Aimn_4U]

Hi All,

I have a combo box set up and would like the user to be able to double click on a record which then populates the particular record into the relevant text box next to it. I would then like them to be able to double click on another record in the same combo box which would then populate as a second item in the relevant text box.

For example, when sending an email to multiple people in outlook you can double click on the person’s name and this name will populate in the ‘To’ Field. When you click on a second person’s name this will populate in the same field after a semicolon.

Any help with a code to do this would be greatly appreciated.

 

[theDBguy]

Hi. If you’re using a combobox, not a listbox, then you won’t even need to use double click. You can use the AfterUpdate event instead. The code might look something like this:

Me.TextboxName=Me.TextboxName & ";" & Me.ComboboxName

 

[Aimn_4U]

Thank you TheDBguy you have just made my day!