How to create a drop down list in Access
|
Show In this tutorial, we will teach you how to create drop-down list in Access. Drop down lists refer to drop down menus from which you can select one of the given options. In Access, you can create a dropdown list. Step 1 – Open table in design view For the purpose of this tutorial, we will be using a pre-existing database. There are several tables in this database. Go to view and select the design view in order to view the back end of the table.
Step 2 – Lookup wizard Once the table opens up in design view, insert a new row. For the purpose of this tutorial, we will be creating a gender field. Here, we will select the lookup wizard as the data type for the field.
Step 3 – Type the values for the dropdown list As a result, the lookup wizard will appear on your screen. Select the second option that allows you to type in the values that you want in access’ dropdown list. Click on the next button to proceed. Step 4 – Complete the lookup wizard Now enter the items that you want in the drop down list. In this tutorial, we are creating a drop down list for gender, thus, we will type in male and female. Once you are done adding the list contents, click on the next button. Once you are done, click on the finish button to exit the wizard.
Step 5 – Save Changes Now go to the view drop down button and choose the datasheet view. You will be asked if you want to save the changes that you just made. Click on the yes button to save the changes.
Step 6 – Open table in datasheet view When the table will appear in datasheet view, you will see the gender field that you created. Click on it and you will be presented with a drop down list containing the male and female options that you have allowed for the respective field. In this manner, you can create a drop down lists in Access.
This Access tutorial explains how to add dropdown list in Access Table Field using List Box and Combo Box. Add dropdown list (Combo Box) in Access Table FieldSuppose you have two tables. Personal_data – store personal information of employees
Job_data – store the position title of an employees
For an HR database, a personal record is created before Job record is created. Therefore we can add a dropdown list for Employee_ID in Job_data Table, using the Employee_ID from Personal_data. Setup dropdown list (Combo Box) using Lookup WizardRight click on Job_data Table > Design View > in Data Type, select Lookup Wizard Select “I want the lookup field to get the values from another table or query” Select “Table: Personal_data” Select “Employee ID” Select sorting order Adjust field width Click Finish Now go back to the Design View of Job_data Table In the Lookup tab of Employee_ID field, the Display Control has changed to Combo Box, and Row Source becomes a SQL statement. (Row Source is what you can select in Combo Box) If you don’t know SQL, click on the … button on the right of Row Source, then you will go to Query Builder interface. If the value is duplicated in the source, add DISTINCT keyword in SQL after keyword SELECT, or GROUP BY the required field in Query Builder. Example – Add dropdown list (List) in Access Table FieldWe just learned how to use another Table Field value as a Row Source, we can also manually define the list value. Let’s say we want to use to select from a list of Position. Go to Design View of Job_data Table, set up the Lookup tab of Position Field as below. Allow Value List Edits is optional, but it can help you quickly edit list items in Data View. You can do it with Combo Box or List Box, as both Properties in Lookup tab are extremely similar (both allow multiple selection). However, I would suggest to use List Box for custom values, because you can edit the Row Source easily using the Edit List Items windows, Combo Box does not have it. Go to Data View of Job_data Table, you can now select a position. Outbound Referenceshttps://support.office.com/en-us/article/Create-a-list-of-choices-by-using-a-list-box-or-combo-box-70ABF4A9-0439-4885-9099-B9FA83517603 |
