Using two list boxes, move items between them

[jahlmer]

Here's my back-end:

tblAuthors
AuthorID Autonumber
AuthorName Text

tblDocs
DocID
AuthorID1
AuthorID2
AuthorID3
AuthorID4


I have two list boxes, with two buttons between them (> and <).

I want to be able to see a list of all the authors, and author ID's on list1, and be able to click the > to move them into list2. A max of 4 would be allowed in that list, and would populate the AuthorID1, 2, 3, 4 in the tblDocs table.

Any help is appreciated

 

[braindead2]

set list box 2 row source type to value list then in the on double click event of listbox1 one place this code

Me.List2.RowSource = Me.List2.RowSource & Me.List1.Value & &quot;;&quot;

 

[braindead2]

sorry did not read close enough code posted will move it as they click on selection. will post for multiselect in a few minutes