- 1). Open Access 2007 and click a database in the right "Open Recent Database" list. The database opens.
- 2). Review the Navigation Pane and double click a table to open it. Click the "View" button the ribbon and select "Design View."
- 3). Select a field in the table and locate the lower "Field Properties." Click the "Lookup" tab. Change the "Display Control" to "List Box." Change the "Row Source Type" to "Value List."
- 4). Add the values for the drop down list in the "Row Source" field. For example, if users will have an drop down list in the "Location" field, add the following choices in the "Row Source" field, "New York;Seattle;Orlando"."
- 5). Click the "Save" icon on the Quick Access Toolbar. Click the "View" button on the ribbon. Click in the Location field and notice the drop down list with the typed choices.
SHARE
