Hello,

i have a problem getting values from a list box. The list box has the first column as the bound value and the data for the listbox is generated from a lookup query. I want to pass both values through to a form when i click on the listbox row(Click event). Currently i can only get one value being the bound value. I was wondering, do the values get passed as an array? IS there anyway to get the value i want?

it looks like this


[Time ][Name.... ]
[ 9:00][ ]
..
[11:00][Paul Fuller ]
..
[17:30][ ]

Any ideas or suggestions very welcome.


Cheers Paul



[This message has been edited by Pjfuller (edited 09-22-2001).]

'to set a control to the first value in your combobox column
Me.ControlName1 = ComboxName.Column(0)
'to set a control to the next value in your combobox column
Me.ControlName2 = ComboxName.Column(1)

HTH