ACC97: Inconsistent Object Selected in DB Window After Delete

ID: Q165143

The information in this article applies to:

SYMPTOMS

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

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:

   ARTICLE-ID: Q90129
   TITLE     : ACC: How Microsoft Access Deletes Objects from a Database

Additional query words: select highlight cursor
Keywords          : kbui UifDbwin 
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb

Last Reviewed: November 19, 1998