As your Access desktop computer database grows, locating records will involve more than a quick glance in ~ a datasheet. This article describes several approaches you deserve to use to locate records.

You are watching: This object finds and displays selected data


Note: This post doesn’t apply to access web apps – the kind of database you style with access and publish online. See create an access app for more information


What do you desire to do?

Browse with all records

You have the right to browse through documents from the Datasheet see by utilizing the record navigation buttons in ~ the bottom that the table or form.

*

1. Go to the first record

2. Walk to the previous record

3. Present Record box

4. Go to the following record

5. Go to the critical record

6. Open a new (blank) record

7. Filter indicator

8. Search box

You can also use the TAB key to move through one document at a time.

top of web page

Go come a certain record

When you understand which record you want to find, usage the Go to box to select a specific record from a drop-down list. The go to crate is usually supplied in forms.

*

To navigate to a record, click the arrowhead to the ideal of the Go to box, and then pick a document from the drop-down list.


Note: If you recognize the first few characters of the document to i beg your pardon you desire to navigate, you can form those personalities in the Go to box.


The Go to box display screens only sufficient data to uniquely determine each record. As soon as you pick a record from the list, access displays the rest of the record"s data in the key area the the form.

height of web page

Search for a record

When you go into text in the Search box, the an initial matching value is highlighted in genuine time as you go into each character. You have the right to use this attribute to easily search for a document with a matching value.

You can additionally search for a certain record in a table or kind by utilizing the Find option.

*

This is an effective an option for locating a specific record once the document that you want to find satisfies details criteria, such as search terms, and comparison operators, such together "equals" or "contains".


Note: You have the right to only usage the Find and Replace dialog crate if the table or type currently screens data. This is true even if there are no visible records due to the fact that a filter has actually been applied.


Open the table or form, and also then click the ar that you desire to search.

On the Home tab, in the Find group, click Find.

The Find and also Replace dialog box appears, with the Find tab selected.

*

In the Find What box, form the value for i beg your pardon you desire to search.

To change the field that you desire to search or to search the entire underlying table, click the appropriate option in the Look In list.


Tip: The Match perform represents your comparison operator (such together "equals" or "contains"). To increase your search, in the Match list, click Any part of Field.


In the Search list, pick All, and then click Find Next.

When the item because that which you are searching is highlighted, click Cancel in the Find and also Replace dialog box to close the dialog box. Records that enhance your problems are highlighted

peak of web page

Filter come display particular records

You have the right to filter to view a minimal number the records when you desire to see only the documents that satisfy details criteria and also comparison operators. Because that example, to conveniently narrow the records that room displayed, right-click a ar whose worth you want to match, and also then select Equals, Does not Equal, Contains, or Does not Contain in ~ the bottom the the faster way menu. A filter deserve to be turn on or off, which makes it simple to switch between filtered and also unfiltered views of the very same data. Uneven search, a filter only borders which the the documents are displayed.

To apply a filter the is based on a selection, open a table or form.

To make sure that the table or kind is not already filtered, top top the Home tab, in the Sort & Filter group, click Advanced, and then click Clear every Filters, if the command is available.

Navigate come the document that consists of the worth that you want to use as component of the filter, and then click inside the column (in Datasheet view) or regulate (in Form, Report, or Layout view). Come filter based on a partial selection, select just the characters that friend want.

See more: P0452: Evaporative Emission Control System Pressure Sensor Low Input

On the Home tab, in the Sort & Filter group, click Selection, and also then click the filter you want to apply.