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


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

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?.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP KB203156
©2004 Microsoft Corporation. All rights reserved.