Microsoft KB Archive/203156

= ACC2000: #Name? Error After You Demote a Parent Field on a Data Access Page =

Article ID: 203156

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q203156



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 demote the parent field of a grouped data access page, the child field that is used for grouping the data displays #Name?



RESOLUTION
Because promoting the child field and demoting the parent field causes the control source of the child field to be a grouped control, reset the control source of the problem field to its original value.



Steps to Reproduce the Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) Create a blank data access page.
 * 3) Drag the CompanyName field from the Customers table into the Section: Unbound section.
 * 4) Drag the OrderID field from the Orders table to the top edge of the NavigationSection: Customers bar. Drop the field onto the data access page when you see the blue line with inward pointing arrows on each end. This creates the section Header: Orders.
 * 5) Drag the OrderDate field into Header: Orders section.
 * 6) Preview the page, and note that the related orders appear correctly under each customer.
 * 7) Return to Design view and drag the OrderID field from Header: Orders section into the Header: Customers section. This forces the field to become a grouped control and, in this instance, creates a total of the OrderIDs for each customer. View the properties for this control and note that the ControlSource property is now set to GroupOfOrderID: OrderID.
 * 8) Click the CompanyName control, and then click Demote on the toolbar. Note that in Page view, the OrderID field now displays #Name?.

Additional query words: prb pound name poundname question mark questionmark poundnamequestionmark error

Keywords: kbbug kbdap KB203156

-

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

© Microsoft Corporation. All rights reserved.