Hi guys, I'm new to VB/VBA and my question is very simple (I hope). I have 2 listboxes in my Access form. Can anyone help me with a code for a button that moves items from the first listbox to the second one. My first list box gets it's data from a table. Thanks,

It is easy to do this with normal listboxes: ListBox 1 Name: left_list ListBox 2 Name: right_list Command Button Name: CopyList To copy from the 1st box to the 2nd: Private Sub CopyList_Click() Dim item As String For i = 0 To right_list.ListCount - 1 right_list.RemoveItem (0) Next i For i = 0 To left_list.ListCount - 1 item = left_list.ItemData(i) right_list.AddItem (item) Next i End Sub To do more requires more information about the source of the data from you.

While the above code will copy the entire contents of List1 to List2, the following code will just copy selected items by double clicking on the item to be copied. Private Sub List1_DblClick() List2.AddItem List1.list(List1.ListIndex) List1.RemoveItem List1.ListIndex End Sub Stuart

How can i use command Button to open folder in DirListBox like a user does?

Link it to a FileListBox. If you have a new question, start a new thread. Otherwise there is a good chance it will not get answered. Stuart