Add to listbox with multiple columns

[rirus]

Using an Access Form with two listboxes... List1 and list2 with two columns
in each list. when I click an item in list1 I want the data on that row to go
into list2 with the columns reversed.

IndexNum = 0
List1.column(1, List1.Listindex) into List2.column(0, IndexNum) &
List1.column(0, List1.Listindex) into List2.column(1, IndexNum)

I can enter List1.column(1, Listi.listindex) into the first column of List2
but do not know how to enter data into the second column of List2.

Any ideas?

 

[Doug Robbins - Word MVP]

I can't imagine the purpose of the exercise, but I suggest that you ask this
question in an Access newsgroup. This one is for the use of VBA in Word.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[rirus]

Sorry, thought I was in Access VBA. I am really confused.