Filtering a Drop-down List

When searching within a field list for a particular value, you can limit the contents of the list to make it easier to find the desired value.

To filter a field list:

Click in a field list box.
If there is a value in the box, delete it.
Specify the characters you want to match. You can use one or more instances of the wildcard character to broaden or narrow your search. For more information, see Using Wildcard Characters.
Click the arrow in the field.

The system displays a list consisting of items that match your criteria. The number of items displayed is limited to the current cap on lists. See About Caps.

Note:

You can filter only on drop-down lists for business-data list boxes. See About Lists in Fields.
Comparison operators are not supported in filtering drop-down lists. See Operators on Query Forms.
Validators do not run in Filter-In-Place mode.
In two-column lists, which show an identification number in the left column and a name or description in the right column, filter criteria apply only to the left column. Also, the left column may contain leading spaces and thus require a preceding wildcard when you enter filter criteria.

For example, to find ID numbers starting with 3 in a two-column list, you might need to specify *3*.

To filter on data in the right column, use the Find feature, if it is available, to open a query form. See Finding a Specific Value in a Drop-Down List.