[RESOLVED] adding item from one listbox to another

[Ecniv]

Example:

Table:
ID field1 flag
1  This   false
2  Is      false
3  The   false


\/

List box (left displays all)

the you set the flags to true and the right list box displayas them.

The first column width must be 0 (so it is hidden) and holds the ID for the record.

The code under the button updates the flag field to false or true depending which way you want the record value to move.

(You can use an Update sql statement and execute it - works with IN or EXISTS with a multi select listbox.)