PRB: Form's Record Sort Order Depends on AllowUpdating

The information in this article applies to:

• Microsoft Access versions 1.0, 1.1, 2.0

1. Start Microsoft Access.
2. Create a new table with a text field. Make the text field the primary key.
3. View the table in Datasheet view. Enter three new records with the following values:

         Z
         X
         Y
   

4. Create a new, blank form based on the new table.
5. Add a text box to the form. Set the text box's ControlSource property to the text field you created in step 2.
6. View the form in Form view. Note that the display order is:

         X
         Y
         Z
   

7. View the form in Design view. Set the form's AllowUpdating property to No Tables.
8. View the form in Form view. Note that the display order has changed to:

         Z
         X
         Y