Create a new form from Form Designer. The Data source is No table. Change the form title to Populate Company Name from NWIND Database. Then, place the following controls on the form:
A text box with the text Company Name:
A combo box named COMPANIES, and with the settings shown below:
The Style is Drop down list because we want the user to be restricted to the list of companies in the Northwind database. (The Drop down style would be used if the user can see the list but could enter another value.)
The Vert. scroll bar check box is checked because the list is larger than the depth of the combo box. The user probably needs to scroll to get to the desired selection.
Be sure to give the combo box some depth (for at least 4 entries). If you do not give the combo box any depth, even if the combo box has entries, the user will not be able to see them.A push button labeled Populate Combo Box.
The form, as designed, should display as shown below:
