Microsoft® Office Access 2003 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 7. 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 Microsoft Access’s Find feature in a form just as you would in a datasheet. First select the field, and then choose the Find command from the Edit menu or click the Find button on the toolbar to open the Find And Replace dialog box that you saw in Figure 7-49. You can enter search criteria exactly as you would for a datasheet. Note that in ...