Microsoft® Access® 2010 Inside Out

Searching for and Sorting Data

When you use forms to display and edit your data, you can search for data or sort it in a new order in much the same way that you search for and sort data in datasheets. (See Chapter 9.) The following sections show you how to use some of the form filter features to search for data in a form or use the quick sort commands to reorder your data.

Performing a Simple Search

You can use the Find feature of Access 2010 in a form exactly as you would in a datasheet. Open the frmContactsPlain form if you closed it, select the field you want to search, and then click the Find command in the Find group on the Home tab to open the Find And Replace dialog box, as shown in Figure 12-36. You can enter search criteria exactly as you ...