sir ,

I have an application in that i have 3 dropdown in which i have entered day ,month ,year separately and in database i have stored this date in combined form suppose2/3/2009.so when i want to update this date then how i can do that becoz now date is in combined form how to separate this date in three dropdown

dim somedate as string
somedate = "2/3/2009"
parts = split(somedate, "/")

if ubound(parts()) < 2 then
     msgbox "Error Parsing Date String"
     exit sub
else
     mymonth = somedate(0)
     myday = somedate(1)
     myyear = somedate(2)

     combo1.additem(mymonth)
     combo2.additem(myday)
     combo3.additem(myyear)
end if
commented: Nice +6