I am designing a new form which allows a user to be assigned to groups. Therefore when you double click the user a form is presented with 2 listboxes. The first listbox is a list of available groups (listbox) bound to a table. The 2nd listbox is a list of groups the user is assigned to. Its a like to mover class. When you click on a group to add the user to I select the usergroups table which appends a new record and adds the user and group to the table and then refresh the listbox. This works great. Only that the group is not removed from the available groups is this is a list from a table. How can I do this so that when you select a group it removes from list one and shows in list 2?
Neil Lewis
IT R&D Manager
Velmore Ltd