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

[cfd33]

This is a 2 part question:

1. I use the following sql statement fill my second listbox (this works fine):

strSQL = "SELECT DISTINCT * FROM Vehicle"

The problem is that only the first item in the first listbox will be affected by the DISTINCT in the sql, but the remaining items in the first listbox will not.

Ex.. If the user selects "BrassTag" from the listbox, then the second listbox will populate with the numbers for "BrassTag" with no duplicates.

When the user selects the next item (ClassCode) from the same listbox, then the second listbox will populate with the data for "ClassCode",but with duplicates.

2. How to get the blank fields out of my listbox? Certain fields in my database have nothing in them and when the sql retrieves the data for my listbox I get blank spaces.

I tried using trim, but it didnt work