Retrieving Collections

Use one of these methods to retrieve the records you need on a form:

  • To return records that match specified criteria in one or more fields, use Filter-in-Place.
  • To specify search criteria and return selected records to a parent form, use query forms.

When you perform these searches, you can usually use filters and wildcard characters. You can also find records where a certain field is blank (null).

You can limit or expand the number of records that a particular search can return.