I have a form that has three fields on it.
One of the fields is a checkbox named "Checkbox". Next to it is a field named "Code". The other field ins named "SelectedCheckboxes". The form is a datasheet form. that has 20 possible checkbox each of the have their own code. Like:
When the checkbox named ABC is checked for example I want the field named SelectedCheckboxes to be populated with "ABC," (note the comma). Then if for example CBA123 is checked I want that to be added to the "ABC," or in other words, "ABC, CBA123". Etc. But I don't want the comma after the last selection.
What would the after update event of the checkbox be?
Also note if a checkbox was previously checked and then Unchecked, I want that code to be removed from the SelectedCheckboxes field.