Thanks for taking a look at my question. I'm trying to create a database to track employee skillsets. I've created multiple checkboxes named after different skillsets each employee may have. I would like a text box under the set of check boxes that displays each skillset checked followed by a coma. For example: If I pull up "Joe" and I have checked, "SharePoint Developer" "Training Analyst" and "JAVA" I would want the text box to display: SharePoint Developer, Training Analyst, JAVA.
For the 1st checkbox (JAVACheck) I have an event procedure that looks like this:
Private Sub JAVACheck_Click()
If Me.JAVACheck Then
Me.Skillsets = "JAVA, "
Else
Me.Skillsets = ""
End If
End Sub
and it will populate the text box (Skillsets), BUT if I check another box, JAVA is removed from the text box and replaced with the new skillset, even though JAVA is still checked. How can I make it so that it keeps adding to the text box vs removing the previous entry and adding the new?
Thanks!