List bpx not displaying any data

[Shamli]

Hello Everyone.
I am trying to display data based on the list box selection.
this is the query:

SELECT Projects_T.ProjectID, Projects_T.ProjectName, Element_T.Element, EmpToProj.EmployeeID, EmpToProj.StartDate, EmpToProj.Enddate " _
& "FROM (Element_T INNER JOIN Projects_T ON Element_T.ElementID = Projects_T.ElementID) INNER JOIN EmpToProj ON Projects_T.ProjectID = EmpToProj.ProjectID " _
& "WHERE (SELECT EmployeeID FROM EmpToProj " _
'& "WHERE EmployeeID = " & lstEmployee.Column(1) _
& "ORDER BY Element;"

What am I doing wrong here?

[ranman256]

Do not use listbox columns in a query.
set the Bound column in the listbox,
then query on the list. No column needed.
then it will work.

[June7]

This is VBA constructing SQL statement? Why the nested query? EmployeeID is actually in second column? Need space in front of ORDER so compiled string doesn't run together.

& "WHERE EmployeeID = " & Me.lstEmployee.Column(1) & " ORDER BY Element;"