Pre-Select an Item in FieldFilter Dropdown

Normally, a Table Report page displays all records in a database table or view when the default value in the FieldFilter is set to "All".  Sometimes, you might want to display records specific to a particular FieldFilter value when the page is initially displayed. For example, you might initialize a Show Customers page to display only the customers located in Berlin via the “Initialize” event.

Step 1:  In the Layout Editor, select the filter dropdown list control and open the Property Sheet, Actions group.

Step 2:  Select the ‘Initialize’ event and enter this formula.

= “Berlin”

Step 3:  Build and run your application.

See Also

Common Formula Examples