Populating Dropdown list by date and then by ID

I have 2 dropdown list gets populated like this (I have shown the comma to seperate the 2 dropdown lists). The query I use is strSql = "SELECT categoryid, date FROM Marketdata ORDER BY categoryid".

I assign the first dropdown list with date and the 2nd with the category ID (unique). I want only 1 instance of a particular date to be listed. On selecting that date, the 2nd dropdownlist will show the 4 corresponding categoryids for that date. How do I do this. Right now my 1st dropdown list has the same date listed four times. Should I modify the above query..if so how? Or should I change my VB code?



12/10/2003, 9
12/10/2003, 8
12/10/2003, 7
12/10/2003, 6
12/09/2003, 5
12/09/2003, 4
12/09/2003, 3
12/09/2003, 2

Try to not post a question in multiple locations. It makes things a little confusing when it comes time to answer questions. Pick the forumn that best fits the question at hand and put it there, once.

S-