Event Handler Parameters - Specify Form Run Options

This version of the Event Handler Parameters form is used with form events that have been assigned any of these Response > Types:

  • Goto Form
  • Run Form
  • Run Form as Linked Child
  • Run Form as Modal Child
  • Run Form to Retrieve Filter

For components that support shortcut menus for Find, Add, and Details forms, use this form to set up and maintain specifications for opening the relevant form.

For event handlers with one of the form navigation response types, use this form to set up and maintain the specifications which run or execute a form based on an event.

Field/Option Description
Form Specify the internal name (not the caption) of the form to be run.
Filter This is the filter to be applied to the form being opened. Specify the filter as a SQL WHERE clause using the FILTER keyword and property names as parameters (instead of column names). You can include substitution keywords.

The entire string, after any substitutions are performed, is passed to the IDO in its Filter property prior to the load collection call.

If the filter is for a subcollection, and there are substitutions for variables included in it, then a dependency is created between the subcollection and the variable. When the variable's value is changed, the subcollection is refreshed.

If the filter is for a list source, and there are substitutions for variables included in it, then a dependency is created between the list source and the variable. When the variable's value is changed, the list source is invalidated.

Distinct To apply the DISTINCT keyword to the primary collection on the form being opened, select this option. Otherwise, clear it.
OrderBy Specify the ORDERBY keyword, which controls the sorting of the primary collection on the form being opened.
GroupBy Specify the GROUPBY keyword for the primary collection on the form being opened.
Set Variables Specify values for variables, components, or properties used in the event handler.
Property This field applies only to opening an Add/Details form. Specify the property in the parent form that is used to filter the child form being opened.
OK/Cancel/Optional This field applies only to opening modal child forms. To eliminate the OK or Cancel prompt when a user closes a modal child form with the Close box, select this option.

To have the prompt display, clear this option.

Popup Window To have the form display in a pop-up window, select this option.

See About pop-up forms.

Reload After Child Saves (RLACS) This field applies only to opening linked child forms.

To refresh the current IDO item in the parent form's collection after the child form's primary collection is saved, select this option. Otherwise, clear the check box.

Use this option in cases in which saving the child form might cause the data in the parent form's current item to be obsolete.

LinkBy This field applies only to opening linked child forms. Specify the Windows client LINKBY keyword.
Set Variable On Link Update This field applies only to opening linked child forms. Specify targets and values for variables