ACC97: Inconsistent Object Selected in DB Window After Delete (165143)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q165143
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

After you delete an object from the Database window, the object that is selected next seems random and inconsistent. For example, when you delete a form, the form that is selected next is not necessarily the form that appears immediately before or after the one you deleted.

CAUSE

After you delete an object from the Database window, Microsoft Access recreates an unsorted list of the remaining objects of that same type, and automatically selects the first item on the list. The selected item might be any of the remaining objects on the same tab in the Database window.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Click the Forms tab in the Database window, and select the Customers form.
  3. On the Edit menu, click Copy.
  4. On the Edit menu, click Paste.
  5. In the Paste As dialog box, type frmDelete1, and then click OK.
  6. Repeat steps 4 and 5 to create two more forms: frmDelete2 and frmDelete3.
  7. Select frmDelete2, and then click Delete on the Edit menu. Click Yes when prompted if you want to delete the form.
Note that the selected form in the Database window is something other than frmDelete1 or frmDelete3.

REFERENCES

For more information about how Microsoft Access deletes objects, please see the following article in the Microsoft Knowledge Base:

90129 ACC: How Microsoft Access Deletes Objects from a Database

Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb kbui KB165143
©2003 Microsoft Corporation. All rights reserved.