Excel: Finding a Record Using the Data Form

ID: Q45245

The information in this article applies to:

SUMMARY

To find a record in a data form in Microsoft Excel version 2.20 or 3.00, do the following (these steps assume you have correctly defined a database range):

  1. From the Data menu, choose Form and drag the scroll bar up to the top if it isn't there already. Record 1 should be displayed in the Form window.


  2. Click the Criteria button.


  3. Type the criteria you want to search on in the appropriate fields. You can have only one criteria per field in the data form.


  4. Click Form to toggle back to the Form window. Record 1 will be displayed.


  5. Click Find Next. The next record that fits the criteria described earlier will be displayed.


To scroll through the records in the database that match the defined criteria, click Find Next and Find Previous.


MORE INFORMATION

Using the data form, you cannot find records based on computed criteria or criteria consisting of ANDs and/or ORs. To find records based on this type of criteria, the criteria range must be created using the method described on pages 327-337 in the "Microsoft Excel User's Guide 1," version 4.0 manual. If you are using version 3.0, refer to pages 369-378 of the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see pages 166-173 of the "Microsoft Excel Reference" version 2.2 manual.

Additional query words: noupd 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 15, 1999