ComboBox Row Source = Result of DB Query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zachary Turner - 24 Sep 2004 20:22 GMT

I have an access database and I want to populate a combo box with the
contents of a Table in my access database. What is the best way to do
it? I was trying to do it at design time, but not sure if it can be
done.

Reply to this Message

Sijin Joseph - 26 Sep 2004 15:56 GMT

The easiest way would be to drag the table from server explorer (you
will need to create a new DB connection to the access table in the
server explorer to be able to view the table) onto your form, the
required connections and adapters get automatically setup, create a
dataset by r-clicking on the adapter, next set the datasource property
of the combo to the dataset.

These articles describe this in detail
http://www.developer.com/net/vb/article.php/3092741
http://www.startvbdotnet.com/ado/server.htm

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

> I have an access database and I want to populate a combo box with the
> contents of a Table in my access database. What is the best way to do
> it? I was trying to do it at design time, but not sure if it can be
> done.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...