You can choose to filter the active value list on the Filtered by tab.
To filter the active value list:
- In the Filtered by step of the Value List Wizard, click the Filtered by field.
- In the Select Value List dialog box, choose the list you want to use as the filtering value list. The values of the filtering value list are loaded into the Value drop-down list.
- Select a filtering value from the Value drop-down list.
From the list on the left, select the values to be filtered. You can use the Ctrl and Shift keys to select multiple values. Click Add to add the selected values to the list of filtered values on the right.
- Repeat this process as necessary using other filtering values.
Every time you add a value from the left list to the right list the value receives a
(assigned value) icon. This way you can tell which values of the filtered list have already been assigned to a value in the filtering list. Unassigned values show the 
(unassigned) icon.There is no limit on the number of times you may assign a value. For example, if you were to filter a value list of countries by language, Canada will appear twice—once filtered by the English list and then again filtered by the French list.
- Click Next to proceed to the next step of the Value List Wizard, or click Finish to save the value list and exit the Value List Wizard.