ACC2000: Editing Records in a Page Causes Immediate Sort

ID: Q222453


The information in this article applies to:

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


SYMPTOMS

When you add a new record or edit an existing record on a data access page, the position of that record within the recordset may change.


CAUSE

The value you changed is a Sort Order field for the page. The record source of pages automatically sorts at the time that you modify the Sort Order field.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. In the Database window, click Pages under Objects , and then click New.


  3. In the New Data Access Page dialog box, click Page Wizard.


  4. In the Choose the table or query where the object's data comes from, select the Products table.


  5. Click OK.


  6. Move all fields from the Available Fields list to the Selected Fields list by clicking the >> button, and then click Finish.


  7. On the View menu, click Sorting and Grouping.


  8. In the Default Sort box, type CategoryID.


  9. On the View menu, click Page View.


  10. On the Record Navigation bar, click New Record.

    Note that the Caption box contains Products 1 of 78.


  11. In the CategoryID box, type 2, and then press TAB.

    Note that the Caption box contains Products 25 of 78.



REFERENCES

For more information about the sort order on data access pages, click Microsoft Access Help on the Help menu, type "set or change the default sort order of records on a data access page" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: DAP record specific box prb


Keywords          : kbdta AccDAP DAPProb 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: July 8, 1999