ACC2000: Name Appears Twice in Display Form/Page List (199803)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q199803

SYMPTOMS

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

The Display Form/Page list in the Startup dialog box may contain the same name twice.

CAUSE

There is a form and a data access page with the same name.

RESOLUTION

Method 1

Give each object a unique name so that you can distinguish one item from another in the Display Form/Page list.

Method 2

Use the following steps to create a macro that will open the appropriate object each time that you open the database.
  1. In the Database window, click Macros under Objects, and then click New.
  2. Create one of the following macros:
       Macro to Open a Form
       ----------------------------------------
    
          Action
          -------------------------
          OpenForm
    
          Action Arguments
          -------------------------
          Form Name: <form name>
          View: Form
    
          -or-
    
       Macro to Open a Data Access Page
       --------------------------------
    
          Action
          -------------------------
          OpenDataAccessPage
    
          Action Arguments
          ----------------------------------
          Data Access Page Name: <page name>
          View: Browse
    					

  3. On the File menu, click Save As. In the Save Macro '<name>' To box, type AutoExec, and then click OK.

MORE INFORMATION

The name of the form should appear first in the Display Form/Page list; however, the "Resolution" section provides two preferred methods to workaround this issue.

Steps to Reproduce Behavior

  1. Create a new database named Form_Page.mdb.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click OK.
  4. On the File menu, click Save As. In the Save Page '<name>' To box, type Startup, and then click OK. Click Save.
  5. On the File menu, click Close.
  6. In the Database window, click Forms under Objects, and then click New.
  7. In the New Form dialog box, click OK.
  8. On the File menu, click Save As. In the Save Form '<name>' To box, type Startup, and then click OK.
  9. On the File menu, click Close.
  10. On the Tools menu, click Startup.
  11. Click the arrow of the Display Form/Page list. Note that you cannot determine which item is the form and which is the page.

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbDAP kbprb KB199803