Last post Nov 16, 2010 03:38 PM by hugonne
Nov 16, 2010 02:47 PM|PuddinPie|LINK
I'm useing VWDE 2008. I can see my table in my database (tblTeam, [field:Team]) in the database explorer on the left but I'm not quite sure how to get them to populate into a dropdown box. The DB is an access DB called IRISDB.mdb. If anyone knows how ot
accomplish this and could let me know. That would be great. I've been searching for a while and everthing I've tryed has failed.
Nov 16, 2010 03:38 PM|hugonne|LINK
You'll need an DataSource on your page, so that you can bind the DropDownList to it.
First, drag an AccessDataSource to the page, and configure it by following the wizard, which is very simple.
Second, add a DropDownlist, and select your AccessdataSource as its DataSource. Select the field you want to display as the Text field, and the field that has the record id as the value field.
It's pretty straightforward. Once you drop the controls on the form, just use the wizards.
Let me know if you need any more help.