Using links from an Access database to create a dropdownlist that will redirect to another page when an item is selected. Just can't get it to work right.
<asp:DropDownList runat="server" id="DropDownList1" DataTextField="County" DataSourceID="AccessDataSource1" DataValueField="RegionLink" AutoPostBack="True" BackColor="#CCCCFF"></asp:DropDownList>
<asp:AccessDataSource runat="server" ID="AccessDataSource1" DataFile="dBase/MPACT.mdb" SelectCommand="SELECT County, "http://ptimpact.org/Training/" & AssignedRegion & ".aspx" AS RegionLink
FROM Counties">
</asp:AccessDataSource>
