Knowledge Base

ACC97: Inconsistent Object Selected in DB Window After Delete

Article ID: 165143

Article Last Modified on 1/19/2007

Microsoft Access 97 Standard Edition

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

Start Microsoft Access and open the sample database Northwind.mdb.
Click the Forms tab in the Database window, and select the Customers form.
On the Edit menu, click Copy.
On the Edit menu, click Paste.
In the Paste As dialog box, type frmDelete1, and then click OK.
Repeat steps 4 and 5 to create two more forms: frmDelete2 and frmDelete3.
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

Additional query words: select highlight cursor

Keywords: kbprb kbui KB165143