For our Access 2007 users...
Searching for a specific record
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.
1.
Open the table or form, and then
click the field that you want to search.
2.
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.
3.
In the Find What
box, type the value for which you want to search.
4.
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.
5.
In the Search
list, select All, and
then click Find
Next.
6.
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.
___________________________________________________
|
