Dynamic Combobox

hi all,

i have a problem with my VBA user form in which my source data are in the following manner

Date Name Subject Marks
26-Feb-2010 A ENG 100
3-Jan-2010 B CHE 98
26-Feb-2010 A PHY 100
3-Mar-2010 D BIO 98
25-Feb-2010 B MAT 99

im using two comboboxes here one to select the name and next to select the date

what actually the problem is that when i select the name as A i need only the two dates in which A details are available. instead my second combobox is displaying all the dates irrelevent to the user name.

can any one please help me out with sorting the issue

regards
Mahe