Selecting listbox values into another listbox

[DoDo1975]

Hello,

I have created to list boxes. The first listbox lists the values of a certain group in a table. I would like to be able to select one or more of these values in the first listbox, and then press a button to "send" these values into the 2nd listbox. I would also like to be able to delete values out of the second listbox when needed.

This is very similar to many access wizards, just like the create form wizard, so I suspect there might be something built in.

I had thought of creating a temporary table, and displaying the values from this table in the second listbox, appending and deleting records from it as I went along.

Does anyone know the best way to do this, and am I on the right track??

Help appreciated.

Joel Lindsay

 

[chrissie1]

if you have access 2000 or above this might do the trick

private sub button1_click()
If Not IsNull(List1) Then
List2.AddItem List1.Column(0), 0
End If
end sub Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong