Hi there
I have created 2 list boxes on a form in Access. When the user clicks a command button I want the item they have selected in list box 1 to be moved accross to list box 2. I would also like the item selected to be removed from list box 1. List box 1 is populated by values in a table. Also I want to give the user the ability to remove items from list box 2 and put them back in list box 1 via another command button.
I have done this before in VB but never attempted it in Access VBA, can anyone help??
thanks
I have created 2 list boxes on a form in Access. When the user clicks a command button I want the item they have selected in list box 1 to be moved accross to list box 2. I would also like the item selected to be removed from list box 1. List box 1 is populated by values in a table. Also I want to give the user the ability to remove items from list box 2 and put them back in list box 1 via another command button.
I have done this before in VB but never attempted it in Access VBA, can anyone help??
thanks