r15gsy
IS-IT--Management
- Jan 9, 2008
- 22
I have a form with a multi-select listbox of id's and names and addresses.
I have vba code which loops through the multi-select listbox to make a criteria string of id's.
I use the string to create some SQL which updates the names or addresses of all the id's selected.
My problem is that the listbox refreshes and clears my selection.
I want to keep the selection so that it can be re-used.
Any suggestions?
I have vba code which loops through the multi-select listbox to make a criteria string of id's.
I use the string to create some SQL which updates the names or addresses of all the id's selected.
My problem is that the listbox refreshes and clears my selection.
I want to keep the selection so that it can be re-used.
Any suggestions?