Microsoft KB Archive/200423

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

Article ID: 200423

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q200423



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.



Steps to Reproduce the Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Create a new data access page in Design view.
 * 3) If the field list is not already displayed, click Field List on the View menu.
 * 4) Press F11 to switch to the Database window.
 * 5) In the Database window, click the Customers table.
 * 6) On the Edit menu, click Copy.
 * 7) On the Edit menu, click Paste.
 * 8) In the Paste Table As dialog box, type MyTest as the table name.
 * 9) 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.

Additional query words: pra visible doesn't update refreshing

Keywords: kbbug kbdap kbpending KB200423

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.