FilterLookup Property

Microsoft Access Visual Basic

text box control when using the Filter By Form or Server Filter By Form window. Read/write Byte.

expression.FilterLookup

expression    Required. An expression that returns one of the objects in the Applies To list.

Remarks

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.

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.