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

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?.