Virtual Web developer 2005 dropdownlist in ASP 2.0 and the question is about access database?

I have a drop down box in Virtual Web developer 2005 and i use it to populate a dropdown list. My question is I need to use a redirect to the data that is stored in the next field over. for example: i am using SELECT [departments], [Address] FROM [departments]" The departments will give the dropdown list the departments name but how would i redirect to the correspoding address field for the redirect? =\


Any help is greatly apprehiated!


Thanks,


Terry

Virtual Web developer 2005 dropdownlist in ASP 2.0 and the question is about access database?
dropdown has two properties of intrest Text and value. So you dropdown would have the following in its markup


Text='"departments" value="Address"





On the selectedindexchanged event you would do the following


Response.Redirect(DropDownName.Selecte...


Yahoo answers doesnt allow me to put the full code line.


DropdownName SelectedValue property.