ACC97: Inconsistent Object Selected in DB Window After Delete

• Microsoft Access 97

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.

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