Access When form
Completing the Selection tab

Field

Description

Enter a unique number or text to identify this row, such as A, B, C... These labels are referenced in the Logic of Table field. Do not choose and, or, or not as labels.

Enter a property reference. Alternatively, you can enter a literal, a linked property reference or an expression.

Select a comparison to perform on the Field Name value. The system uses the Java compare() function.

Select Equal to require a matching value or values. You cannot test for Java object identity ("==") here.

Ordinarily, the Field Name value and the Value value have the same mode and data type. If the types differ, the system attempts to convert the Value1 data type to the Field Name data type to perform the comparison.

Identify a value to be compared to the value or values of the Field Name value. Enter a literal value (in double quotes) or a property reference, or a more complex expression.

Optional. Enter the Boolean logic operations to be performed at runtime on the rows in the selection table, to compute a True or False result.

You can use and, or, and not in the statement. Use parentheses to indicate the order of evaluation.

When you save the rule, if the form contains only one test row, the system inserts the label for that test row here.

If you have more than one row, the system defaults to listing each test row with an and between them. If that's not what you want, revise it and save again.