ACC: "Undefined Function" Err Msg Referencing Column Property

ID: Q101673


The information in this article applies to:


SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you try to run macro actions that contain a Where clause (ApplyFilter, OpenForm, OpenReport, and FindRecord), and queries that reference the Column property of a combo box or list box on a form, you may receive the following error message:

Undefined Function '[Forms]![Formname]![Controlname].column' in Expression.


CAUSE

Microsoft Access interprets any text followed by opening and closing parentheses as a user-defined function.


RESOLUTION

If you wrap the expression inside the Eval() function as a text string, Microsoft Access will consider the entire reference as a whole, and will not try to parse it. For example:


   Eval("[Forms]![Formname]![Controlname].column(2)") 


STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Access listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Problem


  1. Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0 or earlier), and create a new form based on the Orders table.


  2. Add a combo box control with the following properties:
    
          Form: PromptForm
          --------------------
          RecordSource: Orders
    
          Combo box:
             Name: TheCombo
             RowSource: Orders
             ColumnCount: 4
             BoundColumn: 1 


  3. Save the form as PromptForm, and then close it.


  4. Create the following query based on the Employees table:
    
          Query: ReferenceCombo
          ---------------------
          Type: Select Query
    
          Field: EmployeeID ([Employee ID] in Microsoft Access 1.x and 2.0)
             Table: Employees
             Criteria: =[Forms]![PromptForm]![TheCombo].column(2)
          Field: LastName ([Last Name] in Microsoft Access 1.x and 2.0)
             Table: Employees
          Field: FirstName ([First Name] in Microsoft Access 1.x and 2.0)
             Table: Employees 


  5. Open the PromptForm form in Form view and select an item from the combo box.


  6. Open the ReferenceCombo query in Datasheet view. Note that you receive the following error message: Undefined Function '[Forms]![PromptForm]![TheCombo].column' in Expression.



REFERENCES

For more information about using the Column property in an expression, search on "Column property," and then "Refer to a column in a list in an expression," using the Microsoft Access 97 Help Index.


Keywords          : kberrmsg QryParm 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: March 25, 1999