[RESOLVED] SQL DISTINCT only works for the first item in my listbox

[RobDog888]

Not an actual skip method but by code like this...

With lstQueryResults
    .Clear
    Do While Not rs.EOF
        If Not IsNull(rs.Fields(strQuery).Value) Then
            .AddItem rs.Fields(strQuery).Value & ""
        End If
        rs.MoveNext
    Loop
End With