Results 1 to 2 of 2

Thread: BindingCombo Boxes to MS Access

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2006
    Posts
    2

    BindingCombo Boxes to MS Access

    How do I bind the text portion of a combo box to a table in MS Access while using a pre-defined list (not from a table) in the drop down area? If I can not do this, would I need another table for the drop down portion? If so, how would I bind that table?

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    105,461

    Re: BindingCombo Boxes to MS Access

    You would have to have the DropDownStyle set to DropDown if the values from the table amy not be the same as those you want to add to the list. Once you have retrieved the data from your database into a DataTable you bind it to the ComboBox like this:
    VB Code:
    1. myComboBox.DataBindings.Add("Text", myDataTable, "ColumnName")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width