MultiListbox Union Query

[skea]

I need help here.
i have a multiselect listbox on my form and i want to hard-code its rowsources depending on certain selection criteria.Iam finding a problem. Actually i dont get any results when i use the query below. Any idea what iam missing out.

 Me.OrgTypesLB.RowSource = "SELECT DISTINCT ORG_TYPE FROM tblOrganTypes UNION SELECT" & "All" & " from tblOrganTypes"

Kea

 

[RuralGuy]

How about:
Me.OrgTypesLB.RowSource = "SELECT DISTINCT ORG_TYPE FROM tblOrganTypes UNION SELECT 'All' As Bogus from tblOrganTypes"

 

[skea]

Thanks Man.
i Replaced As Bogus with As Correct.