ACC: New Record Does Not Show in Table After Moving off Record

Last reviewed: March 11, 1998
Article ID: Q175188
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you type a new record in a Microsoft Access table, query, or form, you do not see the new record in the recordset. This may happen if the following conditions are true:

  • You have a table, query, or form that contains more than 255 records.
  • You delete a record, and then insert a record into that same table, query, or form.
  • You press the TAB key or an ARROW key when you have finished typing to move off the record.

    NOTE: This same behavior occurs when you press the ENTER key and you have selected the Move After Enter option on the Keyboard tab of the Options dialog box on the Tools menu.

CAUSE

This behavior occurs because the recordset is not refreshed when you enter the record.

RESOLUTION

In a table or query, to be able to see the newly created record, close and then reopen the table or query.

In a form, on the Records menu, click Sort. You may choose Ascending or Descending.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb.

  2. In the Database window, click the Tables tab.

  3. Open the Order Details table in Datasheet view.

  4. Place your pointer anywhere in the first record, and then on the Edit menu, click Delete Record.

  5. On the Insert menu, click New Record (or Record in Microsoft Access 7.0).

  6. Enter the following new record:

         Order ID     Product     UnitPrice     Quantity     Discount
         ------------------------------------------------------------
          10248     Alice Mutton     $1.00         1          0%
    
    

  7. Press the UP or DOWN ARROW key. Note that the new record does not appear in the list of records.


Additional query words: prb
Keywords : TblOthr
Version : WINDOWS:7.0,97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb
Solution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 11, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.