Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Modifying the Record Navigation Control Properties

By default, the record navigation control on a data access page allows you to perform the following tasks:

• Moving to the next, previous, first, and last record

• Moving to a new record

• Deleting an existing record

• Saving changes to a record

• Cancelling changes made to a record

• Sorting in ascending or descending order

• Filtering data shown on the data access page

There are times when it is not appropriate for all these features to be available. An example would be when you want to provide a page where users simply view employee information over the intranet. To customize the properties of the record navigation control, you must first select it. To do this, click the control while in Design view of the page.

The following sections introduce you to the properties of the record navigation control. Using these properties, you can affect the behavior of the control.

The RecordSource Property

Probably the most important property of a record navigation control is its RecordSource property, which is located on the Data tab of the Properties window. You use it to designate the table or query that underlies the data access page.

First, Previous, Next, and Last Buttons

You can easily add and remove buttons from the Navigation control. Simply right-click the control and select Navigation Buttons. A fly-out menu appears (see Figure 26.32). The First, Previous, Next, and Last options allow you to designate whether the First, Previous, Next, and Last buttons appear on the record navigation control. Selecting the availability of these buttons determines how the user can move through records included in the data access page. You can determine the availability of each button individually. For example, you can opt to include the Previous and Next buttons, but not the First and Last buttons.

The New Button

Selecting or deselecting the New option allows you to determine whether the New button appears on the record navigation control. If included, the user clicks this button to add a new record to the data underlying the data access page. If excluded, unless you provide your own custom Add button, the user is unable to add new records from within the data access page.

The Delete Button

Selecting or deselecting the Delete option allows you to determine whether the Delete button appears on the record navigation control. If included, the user clicks this button to delete the current record. If excluded, unless you provide your own custom Delete button, the user is unable to delete records from within the data access page.

The Save Button

Selecting or deselecting the Save option allows you to determine whether the Save button appears on the record navigation control. If included, the user clicks this button to commit changes made to the controls on the data access page. If excluded, the user can save data by moving to another record after making her changes.

The Undo Button

Selecting or deselecting the Undo option allows you to determine whether the Undo button appears on the record navigation control. If included, the user clicks this button to undo changes made to the current record. If excluded, the user can still undo changes to a record using his Escape key.

The Sort Ascending and Sort Descending Buttons

Selecting or deselecting the Sort Ascending and Sort Descending options allows you to determine whether the Sort Ascending and Sort Descending buttons appear on the record navigation control. If included, the user clicks within the field that she wants to sort on and then clicks the appropriate button to sort in ascending or descending order. The data sorts by the field that the user selected. If excluded, the user is unable to sort the data contained within the data access page.

The ShowToggleFilterButton Button

Selecting or deselecting the Filter By Selection and Filter Toggle options allow you to determine whether each of these filter-related buttons appears on the record navigation control. To use the Filter By Selection button, the user clicks within the field he wants to filter on and then clicks the Filter By Selection tool. The data underlying the data access page is filtered based on the contents of the current field for the current record. For example, in Figure 26.33, the data is filtered so that just the employees with the title of sales appear. You use the Filter Toggle button to remove the selected filter. If you exclude the Filter By Selection button from the record navigation control, the user is unable to filter the data underlying the data access page (unless you provide this functionality via a custom command button).