I have two list boxes and one text box. In general, I would like to set the control source of the text box as:
form.text1.controlsource = form.list1.column(0,i) & " - " &_ form.list1.column(0,i)
i is a variable determined by a loop.
If list1.column(0,1) = read and list2.column(0,1)...