On a form I have a combobox field and a textbox. The combobox field is named cboCCEmployee and the textbox is named txtccEmpEmailAddresses.
The form is bound to a table and in the table are two fields... CCemployee and ccEmpEmailAddresses.
When the user selects a record from the combobox I want the email address (3rd field in the record source query) to populate into the field txtccEmpEmailAddresses. But when the user selects ANOTHER record in the combobox I want that email address to be added to the first email address in the text box but have a comma and a space in between the two. If they select a 3rd record in the combobox repeat all of this. So then the end result is something like this in the textbox:
email@example.com, firstname.lastname@example.org, email@example.com.
Can this be done?