Create a new form from  Form Designer. The Data source is No table. Change the form title to Populate Author Names from PUBS Database. Then, place the following controls on the form:

  • A text box with the text Author Name:

  • A combo box named AUTHORS, and with the settings shown below:

The Style is Drop down list because we want the user to be restricted to the list of authors in the Pubs 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:

  • No labels