NavigationControl.FilterLookup Property (Access)
You can use the FilterLookup property to specify whether values appear in a boundtext box control when using the Filter By Form or Server Filter By Form window. Read/write Byte.
Version Information
Version Added: Access 2010
Syntax
expression .FilterLookup
expression A variable that represents a NavigationControl object.
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 lookup options on the Current Database tab of the Access Options dialog box, available by clicking the Microsoft Office Button |
Always |
2 |
The field values are always displayed. |
.gif "Ff823039.O12FileMenuButton_ZA10077102(en-us,office.14).gif")
and the clicking Access Options.You can also set the default for this property by setting a control's DefaultControl property in Visual Basic.