Microsoft KB Archive/282372

= ACC2002: Lookup Field Is Not Updated When You Change the Lookup Display Column in a View =

Article ID: 282372

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q282372



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

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you change the ProductName field in the Order Details Extended view to a different value, the ProductName field is properly updated to the new value. However, the ProductID is still the product identification number for the original product name and not the corresponding ProductID for the new product name.



CAUSE
The extended properties that are needed to properly look up and change the corresponding ProductID field to a new value were not created.



RESOLUTION
Copy the SQL code of the Order Details Extended view into a new view. You can then modify the product name using the lookup in the ProductID field.



STATUS
This behavior is by design.



Steps to Reproduce the Behavior:

 * 1) Open the sample project NorthwindCS.adp connected to Microsoft SQL Server 2000.
 * 2) Open the Order Details Extended view.
 * 3) For order number 10248, change the product name from Chai to Tofu. Press the down arrow to commit the row. Note that the other rows that previously had Chai as a product name now have a product name of Tofu. However, note that the ProductID is still the product identification number for Chai (1) and not for Tofu (14).

Additional query words: pra prb lookup project adp extended property view refresh

Keywords: kbprb KB282372

-

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

© Microsoft Corporation. All rights reserved.