Please Help Expression is going crazy

[jdwm2310]

I have a query that works great in my other database however I copied it into my current database and it gives me an error stating that "the expression is typed incorrectly, or is it too complex to be evaluated."
Here is my expression:

BusinessUnit is a module I created.

Field:Business Unit: BusinessUnit([CostCenter])
Table: Blank
Total: Expression
Sort: Blank
Short: Blank
Criteria: [Enter Business Unit:]

 

[danvlas]

Try to compile and save all modules. And check for missing references. And if you have Recordset objects, fully qualify them (prefix them with DAO. or ADODB.)

Just guessing...

Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[jdwm2310]

Well when I removed the Criteria. It works but I want my users to specify a business unit. How could i go about doing that??