You can use the FilterLookup property to specify whether values appear in a bound text box control when using the Filter By Form or Server Filter By Form window.
Setting
The FilterLookup property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Never | 0 | The field values aren't displayed. You can specify whether the filtered records can contain Null values. |
| Database Default | 1 | (Default) The field values are displayed according to the settings under Filter By Form Defaults on the Edit/Find tab of the Option dialog box, available by clicking Options on the Tools menu. |
| Always | 2 | The field values are always displayed. |
You can set the FilterLookup property by using the text box's property sheet, a macro, or Visual Basic.
You can set the default for this property by using the text box control's default control style or the DefaultControl method in Visual Basic.
Remarks
If you want to limit the types of fields to display, clear the appropriate check box under Filter By Form Defaults on the Edit/Find tab of the Option dialog box, available by clicking Options on the Tools menu. If field lists aren't displayed, you should increase the number in the Don't Display Lists Where More than This Number of Records Read box so the setting is greater than or equal to the maximum number of records in any field in the underlying source of records.