Auto select in list

[carlton123]

I have a listbox which i select the first value in list with


[List1].Selected(0) = True

but when i try to retrieve the value selected it doesnt work it either is nothing or the last value i manually selected

it does highlight the correct bit though

any help please

 

[carlton123]

sorry a long time since i used VBA in access i didnt put the column(0) bit in works now