FilterLookup Property [Access 2003 VBA Language Reference]

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. 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 property 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.

Applies to | TextBox Object

See Also | Filter Property