Enable List Where Clause
Refer to Add List Boxes and Combo Boxes for general information.
To create a List Where Clause:
- Vertical View for a list box or combo box.
- Click the Advanced Properties tab.
- Enter the WHERE clause in the List Where Clause field.
- Click Save.
NOTE: For nvarchar and nchar database fields, the N must be prepended to string literals in Where Clauses so Unicode characters will not be lost and the value must have single quotes on either side. This is unnecessary for numeric fields.