ACC2000: Current Event of a Data Access Page Does Not Occur When a Section Is Collapsed

MORE INFORMATION

When a grouped data access page is opened, the parent section of the page is automatically current. When the child section is expanded, the child section also becomes current. However, when the child section is collapsed, the parent section does not become current again because the parent section did not lose its current status when the child section gained its own.

Steps to Reproduce the Behavior

1. Open the sample database Northwind.mdb.
2. In the Database window, click Pages under Objects, and then click New.
3. In the New Data Access Page dialog box, click Page Wizard, and then click OK.
4. On the first page of the Page Wizard, add the following fields to the data access page, and then click Next:
   • Categories: CategoryID
   • Categories: CategoryName
   • Products: ProductID
   • Products: ProductName
5. Group the page by CategoryID, and then click Finish.
6. On the Tools menu, point to Macro, and then click Microsoft Script Editor.
7. On the View menu, click Other Windows, and then click Script Outline.
8. Expand MSODSC under Client Objects and Events, and then double-click the Current event.IMPORTANT: When you create VBScript blocks for MSODSC events, you must add a parameter to the event name as follows:

   <SCRIPT LANGUAGE=vbscript FOR=MSODSC EVENT=Current(oEventInfo)>

   The <I>oEventInfo</I> parameter returns specific information about the event to the script. You must add this parameter, whether or not it will be used, because the script will not work without it.
   
   
9. Add the following script to the Current event:

   Alert "The Current event of the MSODSC fired."
   					

10. On the File menu, click Save.
11. Quit the Script Editor.
12. On the View menu, click Page View.
13. Expand the Categories section of the page. Note that the message box is displayed.
14. Collapse the Categories section of the page. Note that the message box is not displayed.