I have a Visual Studio 2008 program with a working 2007 Access Database connected to the project. The data source has been set up and the Data Set. This is my connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\superbooks.accdb
In the database I have a Table named Clients with basic contact information and one of the columns (fields) is Company Name. I want to create a combo box that loads all the "Companies" into that Combo box. When the user selects the company, the other text boxes on the form will reflect the remaining corresponding fields for that record. In other words, when the user selects a "Company" the "First Name, Last Name and Phone number," fields will be displayed in text boxes.