Optimize Filter by Form performance for a specific form

For each text box control on a form, you can specify whether the values stored in the field appear on its list in the Filter By Form window.

1. Open a form in Design view.
   
   
2. Display the property sheet for any text box control.

   How?

3. In the FilterLookup property box, set the property to the setting that will achieve the performance you want.
   • If the list takes too long to display in the Filter By Form window, either set the FilterLookup property to Never, or set it to Database Default and then make the appropriate changes in the Options dialog box (Tools menu). For more information, click .
     
     
   • If the list in the Filter By Form window isn't displaying the values stored in that field, make sure the FilterLookup property isn't set to Never. If the FilterLookup property is set to Database Default or Always, make the appropriate changes in the Options dialog box (Tools menu). For more information, click .