2003 upgrade and globals w/user defined functions

M

Mikky

I recently converted my Access 97 application to Access
2003. I have code in my application that uses user
defined functions for query criteria. For example, I have
a global gblCustomerID and I have a user defined function
named GetCustomerID. The function looks like this:

Function GetCustomerID()
getcustomerid = gblCustomerID
End Function

Then, in my queries, I have getCustomerID()for the
criteria on which customer record to pull up. Now that I
have converted to 2003, these user defined functions can
take up to 5 MINUTES to execute - Access simply stops
responding for awhile and then comes back.

Does anyone know why this would happen?
 
Top