Pulling th column value from list box

[Shamli]

I am trying to take a specific row value from the list box.
I used below as a criteria. But the result I get is all the row and not the specific one I am looking for.

Am I calling the list box column wrongly?


[Forms]![Add EmployeeToProject]![lstEmployee].[Column](1)

[ranman256]

The value is the row. Bound column.
if you want a differen column than the bound, NOTE in vb, columns begin with zero.
listbox.column(0)

you CANNOT use it in a query. That's what bound column is for.