Actions in forms

You can assign the actions in Table 18-1 to buttons you place in a form. Many actions are also available in the toolbar and menu when you run a form.

Because all data is visible in Grid style forms, there are no First, Last, Next, and Prior buttons/actions as there are in the Freeform, Master/Detail One-To-Many, and Master/Detail Many-To-One styles.

For information about placing buttons in a form, see Chapter 20, “Enhancing Forms.”

**Table 18-1: Cross reference of actions to buttons in a form**
Action	Menu item	What the action does	Form styles available in
Apply_Criteria	Rows>Apply Criteria	Validates the selection criteria, then re-retrieves the rows based on the criteria	All
Cancel_Updates	Rows>Cancel Changes	Discards changes made since the last update	All
Clear_Filter	None	Clears the current filter	Freeform, Grid
Clear_Detail_Filter	None	Clears the detail filter	Master/Detail One-To-Many, Master/Detail Many-To-One
Clear_Master_Filter	None	Clears the master filter	Master/Detail One-To-Many, Master/Detail Many-To-One
Close	File>Close	Closes the form (in the InfoMaker environment, returns you to design mode)	All
Delete_Row	Rows>Delete (Ctrl+D)	Deletes the current row in the form	All
Filter_Dialog	None	Displays the Filter dialog box for defining a filter	Freeform, Grid
Filter_Detail_Dialog	None	Displays the Filter dialog box for defining a filter for the detail part of the form	Master/Detail One-To-Many, Master/Detail Many-To-One
Filter_Master_Dialog	None	Displays the Filter dialog box for defining a filter for the master part of the form	Master/Detail One-To-Many, Master/Detail Many-To-One
First_Row	Rows>First	Scrolls to the first retrieved row (in the master area)	Freeform, Master/Detail One-To-Many
Import_File	Rows>Import	Displays the Select Import File dialog box to select a file for importing rows of data	Freeform, Grid
Insert_Row	Rows>Insert (Ctrl+I)	Inserts a new row (in the master area) and scrolls to it with the cursor in the first column	All
Last_Row	Rows>Last	Scrolls to the last row in the form (in the master area)	Freeform, Master/Detail One-To-Many
Next_Row	Rows>Next	Scrolls to the next row	Freeform, Master/Detail One-To-Many
Print	File>Print	Prints the retrieved data	All
Print_Dialog	None	Displays the Windows Print dialog	Freeform, Grid
Print_Setup	File>Print Setup	Opens the Windows Printer Setup dialog box allowing you to change the printer or its settings	All
Prior_Row	Rows>Get Prior	Scrolls to the previous row in the master area	Freeform, Master/Detail One-To-Many
Retrieve	Rows>Retrieve	Retrieves rows from the database and prompts you for criteria if Prompt for Criteria was specified in the workspace	All
Save_As	File>Save Rows As	Saves rows of data in a selected file format, including text format or a Powersoft report	Freeform, Grid
Sort_Dialog	None	Displays the Sort dialog box for defining sorting	Freeform, Grid
Sort_Detail_Dialog	None	Displays the Sort dialog box for defining sorting for the detail part of the form	Master/Detail One-To-Many, Master/Detail Many-To-One
Sort_Master_Dialog	None	Displays the Sort dialog box for defining sorting for the master part of the form	Master/Detail One-To-Many, Master/Detail Many-To-One
Specify_Criteria	Rows>Specify Criteria	Updates the database, then clears the form to allow you to specify selection criteria for the rows For information, see “Limiting the retrieved data”	All
Update_Row	Rows>Update	Updates the current row in the database	Freeform
Update_Rows	Rows>Update (Ctrl+U)	Updates all modified rows in the database	Grid, Master/Detail One-To-Many, Master/Detail Many-To-One