Use Filter By This Value to select a value in a table and then show only the records with the selected value. Select this command, and the application opens the Filter window. However, unlike the window that is displayed by the Filter command, the left side of the window only shows the column that contains the selected value (rather than all columns that may be filtered). Additionally, the filter criteria on the right side are automatically set to be equal to the selected value.
If the filter window shows the proper value and filter expression, select OK to activate the filter. You can also edit the filter value and expression before selecting OK.
See the Filter command for more information about filters.