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.
A push button labeled Populate Combo Box.
The form, as designed, should display as shown below: