ACC2000: "Undefined Function in Expression" Error Message

When you call a user-defined function from within an aggregate (totals) function, such as the Sum() function, in a report, you may receive the following error message:

The user-defined function is located in the report module.

Transfer the user-defined function from the report module to a global module.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce Problem

1. Open the sample database Northwind.mdb.
2. Open the Alphabetical List Of Products report in Design view.
3. Add a text box with the following property to both the detail section and the Product Name footer section of the report:
   ControlSource: =Sum(Notwork())
4. On the View menu, click Code.
5. Type the following user-defined function in the report module:

   Function Notwork()
      Notwork=8
   End function
   					

6. Close the report module.
7. Preview the report.
   
   Note that you receive the error message mentioned in the "Symptoms" section.

For more information about creating modules, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type creating modules in the Office Assistant or the Answer Wizard, and then click Search to view the topic.