ACC2000: Field List and Source Properties of a Page Are Not Updated Automatically When You Create a New Object (200423)

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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you create a new database object while you have a data access page open in Design view, the field list and the source property lists (for such properties as the RecordSource property and the RowSource property) may not display the new object.

CAUSE

The data model on which the field list and source properties rely for their values is not refreshed automatically when you create a new object. These values are not updated until you manually refresh or reopen the field list.

RESOLUTION

To see the new object, use one of the following methods:

Right-click the database name in the field list, and then click Refresh.

-or-
Close and reopen the field list.

-or-
When you create a new database object, save and close the data access page first. Then create the new object, and reopen the data access page.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

Open the sample database Northwind.mdb.
Create a new data access page in Design view.
If the field list is not already displayed, click Field List on the View menu.
Press F11 to switch to the Database window.
In the Database window, click the Customers table.
On the Edit menu, click Copy.
On the Edit menu, click Paste.
In the Paste Table As dialog box, type MyTest as the table name.
Switch back to Design view of the data access page. Note that MyTest is not available as one of the tables in the field list.