Optimize Filter By Form performance for all tables, queries, and forms

These settings affect all tables and queries, and all text box controls whose FilterLookup property is set to Database Default. For more information on setting this property, click .

1. On the Tools menu, click Options.
   
   
2. Click the Edit/Find tab, and then set the Filter By Form Defaults according to the performance you want to achieve.
   • If the list of values takes too long to display in nonindexed fields only, try limiting the lists to indexed fields. You can do this by clearing the check box for Local Nonindexed Fields and ODBC Fields. If the lists take too long to display in indexed fields, clear the Local Indexed Fields check box as well since there are too many records in the indexes for the lists to display quickly.

     Note   If you use the same nonindexed field repeatedly to filter records, consider indexing it to improve filtering and other search operations on the field. For more information, click .

   • If lists aren't displaying the values from indexed or nonindexed fields, check under Show List Of Values In to make sure the appropriate boxes are selected, or try increasing the number in the Don't Display Lists Where More Than This Number Of Records Read box so that it's greater than or equal to the maximum number of records in any nonindexed field in the underlying table.

Note   For information on how Microsoft Access reads records differently in indexed fields than in nonindexed fields and how this difference relates to the Don't Display Lists Where More Than This Number Of Records Read box, click .