Tips for Finding Records

If you cannot find the record you want in a collection, consider these possibilities:

• Are you looking in the correct collection?

  Try changing the focus of the form, to make sure you are focused on the correct collection. You can tell which collection currently has the focus by noting where the cursor is and/or which fields are highlighted.

• Are the correct records retrieved?

  To identify the current filter being used to retrieve records, select Help > About This Form. If necessary, use Filter-in-Place or a query form to retrieve the collection you need. For more information, see one of these topics:

  • Finding Records with Filter-in-Place
  • Finding Records Using a Query Form
• Have you overlooked the record?

  Try sorting the collection. Select Edit > Sort Collection.

  For more information, see Sorting Collections.

  You can also search for a specific value in a field in a collection. Select Edit > Find Value in Collection.

  For more information, see Finding a Value in a Collection of Records.

• Do you retrieve the same collection of records every time you use a form?

  You may want to save your search criteria as a filter so that you can reuse it instead of having to re-enter it every time.

  For more information, see Creating and Saving Filters.