Folks,
I am building a generic method to select multiple items (in this case people) from one large list, and add/or remove them from a list field.
I am not sure however to build the button that moves members between lists. Any pointers would be helpful.
It should be simple, but at this time my head is hurting.
I have attached and image to show what I mean.
- The people in the first column are from the available people (excluding those already in the field office-consultants-list ,
selecting them stores them in a field temp-select-users - The people in the second column are those selected in the First column in field temp-select-users
- The people in the third column are those already selected in the field office-consultants-list
and if selected are stored in the field temp-remove-users
I need help creating buttons to
- Append the people in temp-select-users to the office-consultants-list field
- Remove the people in temp-remove-users from the office-consultants-list field
Of course I want to add and remove from the current office-consultants-list field, not replace it.
I should be able to return a usable macro
Thanks in advance
Tony