Searching for a specific record in Microsoft Access
You can search for a specific record in a table or form by using the Find tab in the Find and Replace dialog box. This is an effective choice for locating a specific record when the record that you want to locate satisfies specific criteria, such as search terms, and comparison operators, such as “equals” or “contains.”
Note: You can only use the Find and Replace dialog box if the table or form currently displays data. This is true even if there are no visible records because a filter has been applied.
- Open the table or form, and then click the field that you want to search.
- On the Home tab, in the Find group, click Find, or press CTRL+F. The Find and Replace dialog box appears, with the Find tab selected.
- In the Find What box, type the value for which you want to search.
- To change the field that you want to search or to search the entire underlying table, click the appropriate option in the Look In list. The Match list represents your comparison operator (such as “equals” or “contains”). To broaden your search, in the Match list, click Any Part of Field.
- In the Search list, select All, and then click Find Next.
- When the item for which you are searching is highlighted, click Cancel in the Find and Replace dialog box to close the dialog box. Records that match your conditions are highlighted.
Learn to use Find and Replace in an Access Introduction class at Full Circle Computing!