Microsoft KB Archive/222453

= ACC2000: Editing Records in a Page Causes Immediate Sort =

Article ID: 222453

Article Last Modified on 7/31/2001

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q222453



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

This article applies to a Microsoft Access database (.mdb) and to 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.



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.
 * 1) In the CategoryID box, type 2, and then press TAB.

Note that the Caption box contains Products 25 of 78.

