Form Navigation Bar
The Form Navigation bar contains icons to edit a database table or to control the data view. The bar is displayed at the bottom of a document that contains fields that are linked to a database.
You can use the Form Navigation bar to move within records as well as to insert and to delete records. If data is saved in a form, the changes are transferred to the database. The Form Navigation bar also contains sort, filter, and search functions for data records.
 | You can use the Navigation bar icon on the More Controls bar to add a Navigation bar to a form. |
 | The Navigation bar is only visible for forms connected to a database. In the Design view of a form, the Navigation bar is not available. See also Table Data bar. |
You can control the view of data with the sorting and filtering functions. Original tables are not changed.
The current sort order or filter is saved with the current document. If a filter is set, the Apply Filter icon on the Navigation bar is activated. Sorting and filtering features in the document can also be configured in the Form Properties dialog. (Choose Form Properties - Data - properties Sort and Filter).
| If an SQL statement is the basis for a form (see Form Properties - tab Data - Data Source), then the filter and sort functions are only available when the SQL statement refers to only one table and is not written in the native SQL mode. |
Absolute Record
Shows the number of the current record. Enter a number to go to the corresponding record.
First Record
|
|
Takes you to the first record. |
Previous Record
|
|
Takes you to the previous record. |
Next Record
|
|
Takes you to the next record. |
Last Record
|
|
Takes you to the last record. |
Save Record
|
|
Saves a new data entry. The change is registered in the database. |
Undo: Data entry
|
|
Allows you to undo a data entry. |
New Record
|
|
Creates a new record. |
Delete Record
|
|
Deletes a record. A query needs to be confirmed before deleting. |
Refresh
Refreshes the displayed data. In a multi-user environment, refreshing the data ensures that it remains current.
|
|
Refresh |
Find Record
|
|
Find Record |
Sort Ascending
Text fields are sorted alphabetically (A-Z), numerical fields in ascending order (0-9).
|
|
Sort Ascending |
Sort Descending
Text fields are sorted alphabetically (Z-A), number fields in numerically descending order (9-0).
|
|
Sort Descending |
AutoFilter
Filters the records based on the content of the currently selected data field.
|
|
AutoFilter |
Form-based Filters
Prompts the database server to filter the visible data by specified criteria.
|
|
Form-based Filters |
Sort
|
|
Sort Order |
Remove Filter/Sorting
Cancels the filter settings and displays all of the records in the current table.
|
|
Remove Filter/Sorting |
Data source as table
Activates an additional table view when in the form view. When the Data source as table function is activated, you see the table in an area above the form.
|
|
Data source as table |
Apply Filter
Switches between the filtered and unfiltered view of the table.
|
|
Apply Filter |
Index
toolbars, Navigation bar
Navigation bar,forms
sorting, data in forms
data, sorting in forms
forms,sorting data
data sources, as tables
This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.
